Examples for business, study, careers, love, and more...
Examples :: MYSQL Examples :: Example of Revoke Mysql statement

Example of Revoke Mysql Statement:

REVOKE ALL PRIVILEGES ON vworks.* FROM badvworks@localhost;
REVOKE INSERT,UPDATE,DELETE ON vworks.* FROM badvworks@localhost;
REVOKE ALL ON test2.* FROM myuid@localhost;

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] ...