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'; |