Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> show grants for anil;
- +------------------------------------------------------------------------------------+
- | Grants for anil@% |
- +------------------------------------------------------------------------------------+
- | GRANT USAGE ON *.* TO 'anil'@'%' |
- | GRANT SELECT, CREATE TEMPORARY TABLES, LOCK TABLES ON `production`.* TO 'anil'@'%' |
- +------------------------------------------------------------------------------------+
- mysql> revoke all privileges, grant option from 'anil'@'%desk%';
- ERROR 1269 (HY000): Can't revoke all privileges for one or more of the requested users
- mysql> revoke usage on *.* from 'anil'@'%desk%';
- ERROR 1141 (42000): There is no such grant defined for user 'anil' on host '%desk%'
- mysql> revoke SELECT, CREATE TEMPORARY TABLES, LOCK TABLES ON `production`.* from 'anil'@'%desk%';
- ERROR 1141 (42000): There is no such grant defined for user 'anil' on host '%desk%'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement