Revoking Object Privileges

You revoke object privileges using REVOKE command.

REVOKE INSERT ON employee FROM tom;

The next example revokes the SELECT privilege on the employee table from tom:

REVOKE SELECT ON store.employee FROM tom;

1. Object Privileges
2. Checking Object Privileges Made, user_tab_privs_made and user_col_privs_made
3. Checking Object Privileges Received
4. Revoking Object Privileges