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