What are the Privileges granted to RECOVERY_CATALOG_OWNER Role in Oracle Database 12c
RECOVERY_CATALOG_OWNER Provides privileges for owner of the recovery catalog. Includes: CREATE
SESSION, ALTER SESSION, CREATE SYNONYM, CREATE ANY SYNONYM,
DROP ANY SYNONYM, CREATE VIEW, CREATE DATABASE LINK, CREATE
TABLE, CREATE CLUSTER, CREATE SEQUENCE, CREATE TRIGGER, CREATE
ANY TRIGGER, QUERY REWRITE, CREATE ANY CONTEXT, EXECUTE ON
DBMS_RLS, ADMINISTER DATABASE, and CREATE PROCEDURE
This predefined role, is automatically defined for Oracle
databases when you run the standard scripts (such as catalog.sql and catproc.sql)
that are part of database creation, and they are considered common roles. If you
install other options or products, then other predefined roles may be created.
#oracledatabase #oracledatabase12c #oracle12c #12c #oracledba #oracletutorial #oracle #oracleroles #oraclepriviliges