Pages

How to revoke privileges of a user on an object?

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