What are the Privileges granted to EXP_FULL_DATABASE Role in Oracle Database 12c
0EXP_FULL_DATABASE Provides the privileges required to perform full and incremental database
exports using the Export utility (later replaced with Oracle Data Pump). It
includes these privileges: SELECT ANY TABLE, BACKUP ANY TABLE,
EXECUTE ANY PROCEDURE, EXECUTE ANY TYPE, ADMINISTER RESOURCE
MANAGER, and INSERT, DELETE, and UPDATE on the tables SYS.INCVID,
SYS.INCFIL, and SYS.INCEXP. Also includes the following roles:
EXECUTE_CATALOG_ROLE and SELECT_CATALOG_ROLE.
This role is provided for convenience in using the export and import utilities.
Caution: This is a very powerful role because it provides a user access to
any data in any schema in the database. Use caution when granting this role
to users.
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