Removing User Access

REVOKE privileges ON db.table FROM user@host; 

Use REVOKE to remove one or more privileges from a user. Use a comma-separated list of privileges or ALL PRIVILEGES to remove all the permissions shown in Table 6.1. To remove all access for a user, including the GRANT OPTION, use a statement like this:

REVOKE ALL PRIVILEGES, GRANT OPTION ON sampdb.mytable FROM 'zak'@'localhost'; 

MySQL Phrasebook. Essential Code and Commands
MySQL Phrasebook
ISBN: 0672328399
EAN: 2147483647
Year: 2003
Pages: 130 © 2008-2017.
If you may any questions please contact us: