The REVOKE statement is the opposite of GRANT . It is used to take privileges away from a user . For example: revoke all on employee.* from fred; The general form of the revoke statement is as follows : REVOKE priv_type [( column_list )] [, priv_type [( column_list )] ...] ON { tbl_name * *.* db_name .*} FROM user_name [, user_name ...] As you can see, it has basically the same clauses as the GRANT statement and can be used to revoke the corresponding privileges. |