Revoking Object Privileges

• REVOKE : To revoke privileges granted to other users
• Privileges granted to others through the WITH GRANT OPTION clause are also revoked.

Syntax]

REVOKE {privilege [, privilege ...] | ALL }
ON   object
FROM {user [,user....]  role | PUBLIC |
[CASCADE CONSTRAINTS];

CASCADE is required to remove any referential integrity constraints made to the CONSTRAINTS object by means of the REFERENCES privileges.

ex)

REVOKE   select, insert
ON           departments
FROM      scott;

** If you drop the user account without revoking privileges from it, then the system privileges granted by this user to other users are not affected by this action. To drop a user, you have to check about privileges granted to the user.