REVOKE System Administrative Permission Syntax
REVOKE User Administrative Permission Syntax
Examples
To revoke system administrator permission from jsmith:REVOKE SYSTEM ADMIN Example
REVOKE SYSTEM READ Example
REVOKE USER ADMIN Example
Privilege Management
REVOKE SYSTEM Permission
System permissions can be
revoked from users or
roles.
To revoke read access to all tables from the auditor role:
To revoke user administrator permission from jsmith: