Advertisement
infogulch

Untitled

Apr 10th, 2012
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.31 KB | None | 0 0
  1.  
  2. CREATE USER 'USR' IDENTIFIED BY 'x';
  3.  
  4. GRANT ALL ON *.* TO 'USR';
  5.  
  6. REVOKE UPDATE ON paymentmethods.*    FROM 'USR'; /* Error:  0   17:12:10    REVOKE UPDATE ON paymentmethods.*    FROM 'HOW' Error Code: 1141. There is no such grant defined for user 'HOW' on host '%' */
  7. GRANT  UPDATE ON paymentmethods.active TO 'USR';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement