Revoking System Privileges from a User

The following example revokes the CREATE TABLE privilege from tom:

CONNECT system/manager
REVOKE CREATE TABLE FROM tom;

The next example revokes EXECUTE ANY PROCEDURE from tom:

REVOKE EXECUTE ANY PROCEDURE FROM tom;

1. System Privileges
2. Use WITH ADMIN OPTION
3. Checking System Privileges Granted to a User
4. Revoking System Privileges from a User