DBO System Role in a Multiplex Environment

By default, the DBO system role is granted the SYS_AUTH_DBA_ROLE compatibility role, ensure that the DBO system role is granted all privileges necessary to execute multiplex management stored procedures.

If you use the ALTER ROLE statement to migrate the SYS_AUTH_DBA_ROLE compatibility role to a new user-defined role, the new role is automatically granted to the DBO system role, provided that SYS_AUTH_DBA_ROLE has not been revoked from the DBO system role.

The SYS_AUTH_DBA_ROLE is immutable. However, once migrated to a new user-defined role, any underlying system privileges can be individually revoked from the new role and granted to other user-defined roles. When this occurs, either the user-defined role to which the system privileges are granted or each individually revoked system privileges must be granted to the DBO system role.

This ensures that all system privileges required to execute multiplex management stored procedures remain granted to the DBO system role.