Example of Revoke Mysql Statement:
REVOKE ALL PRIVILEGES ON vworks.*
FROM [email protected];
REVOKE INSERT,UPDATE,DELETE ON vworks.*
FROM [email protected];
REVOKE ALL ON test2.*
FROM [email protected];
Example of Mysql Revoke
REVOKE
priv_type [(column_list)]
[, priv_type [(column_list)]] ...
ON [object_type] priv_level
FROM user [, user] ...
REVOKE ALL PRIVILEGES, GRANT OPTION
FROM user [, user] ...