How the REVOKE statement works : REVOKE « User Permission « SQL / MySQL






  1. SQL / MySQL
  2. User Permission
  3. REVOKE

How the REVOKE statement works

   

GRANT SELECT, UPDATE
ON test.*
TO 'user1'@'domain1.com' IDENTIFIED BY 'pw1'
WITH GRANT OPTION MAX_QUERIES_PER_HOUR 50 MAX_UPDATES_PER_HOUR 50;

REVOKE SELECT, UPDATE, GRANT OPTION
ON test.*
FROM 'user1'@'domain1.com';








Related examples in the same category

1.REVOKE statement syntax
2.Revoke ALL privileges from the user second, delete the user, and then verify the removal.
3.The REVOKE Statement
4.Revoke select privilege
5.Revoke references privilege
6.Revoke insert and select