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
