MySQL 8 Cookbook

Revoking grants

Revoking grants has the same syntax as creating grants. You grant a privilege TO the user and revoke a privilege FROM the user.

• Revoke the DELETE access from the 'company_write'@'%' user:

mysql> REVOKE DELETE ON company.* FROM 'company_write'@'%';Query OK, 0 rows affected (0.04 sec)

• Revoke the access to the salary column from the employee_ro user:

mysql> REVOKE SELECT(salary) ON employees.salaries FROM 'employees_ro'@'%';Query OK, 0 rows affected (0.03 sec)