Difference between revisions of "MySQL - Delete privileges of a user"

(Created page with "'''Delete (revoke) all privileges of a user:'''<br> REVOKE ALL PRIVILEGES ON mytable.* FROM 'myuser'@'localhost'; <br> '''Delete (revoke) a certain privilege of a user:'''<br>...")
 
Line 1: Line 1:
 +
Use the same privileges string as it is displayed in the output of the command "show grants for 'myuser'@'localhost';"
 +
<br>
 +
 
'''Delete (revoke) all privileges of a user:'''<br>
 
'''Delete (revoke) all privileges of a user:'''<br>
 
REVOKE ALL PRIVILEGES ON mytable.* FROM 'myuser'@'localhost';
 
REVOKE ALL PRIVILEGES ON mytable.* FROM 'myuser'@'localhost';

Revision as of 18:26, 14 April 2020

Use the same privileges string as it is displayed in the output of the command "show grants for 'myuser'@'localhost';"

Delete (revoke) all privileges of a user:
REVOKE ALL PRIVILEGES ON mytable.* FROM 'myuser'@'localhost';
Delete (revoke) a certain privilege of a user:
REVOKE DELETE ON mytable.* FROM 'myuser'@'localhost';
Delete (revoke) certain privilges of a user:
REVOKE DELETE, SELECT ON mytable.* FROM 'myuser'@'localhost';

More info:
https://dev.mysql.com/doc/refman/8.0/en/show-grants.html