Example: Get SELECT, UPDATE privileges on students table back those were given to user zeynal.
REVOKE SELECT, UPDATE ON students FROM zeynal;
Note: If we revoke a privilege from user who had distibuted this role to others by WITH GRANT OPTION, revoke will get this privilige from those people also.
No comments:
Post a Comment