Tuesday, April 19, 2022

Revoke privileges In MySQL

Revoke privileges In MySQL


Example:


revoke privileges on <object> from user;

revoke delete, update on <table_name> from 'user'@'localhost';

revoke delete, update on <table_name> from 'user'@'%';

revoke all on <table_name> from 'user'@'localhost';

revoke all on <table_name> from 'user'@'%';

revoke select on <object> from 'username'@'localhost';

revoke select on <object> from 'username'@'localhost'; 

No comments:

Post a Comment