REVOKE priv_type [(column_list)], ...
ON {tbl_name | * | *.* | db_name.*}
FROM user, ...
This function removes access privileges from a user account. If all privileges are removed from an account, the user will still be able to log in, though he or she simply won’t be able to access any information.
See "MySQL Access Control" for a complete description of this query.