The REVOKE Statement : REVOKE « User Permission « SQL / MySQL

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

The REVOKE Statement

   

REVOKE DELETE, INSERT, UPDATE ON world.* FROM 'jim'@'localhost';


REVOKE GRANT OPTION ON world.* FROM 'jill'@'localhost';

REVOKE FILE ON *.* FROM 'jen'@'myhost.example.com';

REVOKE SELECT ON mydb.* FROM 'jen'@'myhost.example.com';

REVOKE UPDATE ON test.mytable FROM 'jen'@'myhost.example.com';

SHOW GRANTS FOR 'jen'@'myhost.example.com';

USE mysql;

DELETE FROM user WHERE User = 'jen' AND Host = 'myhost.example.com';

FLUSH PRIVILEGES;

   
    
    
  

Related examples in the same category