The SYS_RUN_REPLICATION_ROLE role is granted the SYS_AUTH_DBA_ROLE role with the
WITH ADMIN OPTION clause. It is also granted several system
privileges with the WITH NO ADMIN OPTION clause.
- SELECT ANY TABLE
- SET ANY USER DEFINED OPTION
- SET ANY SYSTEM OPTION
- BACKUP DATABASE
- MONITOR
This default set of system privileges granted cannot be revoked from the role.
Additional system privileges and roles can be granted and revoked from this
role.
Note: The SYS_AUTH_DBA_ROLE role is granted by default to the SYS_RUN_REPLICATION_ROLE
role to address any possible requirements for additional system privileges to
perform other replication related authorized tasks over and above the above-noted
explicitly granted system privileges. It is recommended, however, that the
SYS_AUTH_DBA_ROLE role be revoked from SYS_RUN_REPLICATION_ROLE role and those
specific additional system privileges or roles identified be explicitly granted to
the SYS_RUN_REPLICATION_ROLE role.