Re-creating a Compatibility Role

Re-creates a dropped compatibility role.

Prerequisites

MANAGE ROLES system privilege.
Administrative privileges on all of the system privileges granted to the compatibility role being re-created.

Task

Re-creating SYS_AUTH_DBA_ROLE is semantically equivalent to re-creating both the SYS_AUTH_SA_ROLE and SYS_AUTH_SSO_ROLE roles; you cannot re-create these two roles separately.

When you re-create any compatibility role other than SYS_AUTH_DBA_ROLE, administrative privileges on the re-created compatibility role are automatically granted to SYS_AUTH_DBA_ROLE, as long as it still exists.

When you re-create any compatibility role other than SYS_AUTH_DBA_ROLE, or SYS_AUTH_PERMS_ADMIN_ROLE, administrative privileges on the re-created compatibility role are automatically granted to SYS_AUTH_PERMS_ADMIN_ROLE, as long as it still exists.

To re-create a compatibility role, execute:

CREATE ROLE compatibility_role_name [ WITH ADMIN [ONLY] userid [, ...] ]