Advertisement
Guest User

Untitled

a guest
Feb 7th, 2014
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.00 KB | None | 0 0
  1. mysql> show grants for anil;
  2.  
  3. +------------------------------------------------------------------------------------+
  4. | Grants for anil@% |
  5. +------------------------------------------------------------------------------------+
  6. | GRANT USAGE ON *.* TO 'anil'@'%' |
  7. | GRANT SELECT, CREATE TEMPORARY TABLES, LOCK TABLES ON `production`.* TO 'anil'@'%' |
  8. +------------------------------------------------------------------------------------+
  9.  
  10.  
  11. mysql> revoke all privileges, grant option from 'anil'@'%desk%';
  12. ERROR 1269 (HY000): Can't revoke all privileges for one or more of the requested users
  13.  
  14. mysql> revoke usage on *.* from 'anil'@'%desk%';
  15. ERROR 1141 (42000): There is no such grant defined for user 'anil' on host '%desk%'
  16.  
  17. mysql> revoke SELECT, CREATE TEMPORARY TABLES, LOCK TABLES ON `production`.* from 'anil'@'%desk%';
  18. 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