Solutions

Solution Exercice 1 :

GRANT SELECT, UPDATE ON bibliotheque.* TO 'marie'@'%';

Solution Exercice 2 :

REVOKE UPDATE ON bibliotheque.* FROM 'marie'@'%';

Solution Exercice 3 :

SHOW GRANTS FOR 'jean'@'localhost';

Last updated