All compatibility roles, with the exception of SYS_AUTH_SA_ROLE and
SYS_AUTH_SSO_ROLE can be dropped. SYS_AUTH_SA_ROLE and SYS_AUTH_SSO_ROLE are automatically
dropped when SYS_AUTH_DBA_ROLE is dropped.
Prerequisites
- Administrative privilege over the role being dropped.
- Each of the system privileges granted to a compatibility role is granted to at least
one user-defined role.
Task
The
WITH REVOKE clause is only
required when dropping a compatibility role that is currently granted to users or roles.
You can re-create any dropped compatibility role. See
Re-creating Compatibility
Roles.
To delete a compatibility role, execute one of these
statements:
Drop Condition |
Statement |
Compatibility role not currently granted to any user or role. |
DROP ROLE
role_name* |
Compatibility role currently granted to users or roles. |
DROP ROLE
role_name*
WITH REVOKE |
*role_name cannot be SYS_AUTH_SA_ROLE or SYS_AUTH_SSO_ROLE.