| Role Name | Privileges Granted To Role |
|---|---|
|
CONNECT 1 |
ALTER SESSION, CREATE CLUSTER, CREATE DATABASE LINK, CREATE SEQUENCE, CREATE SESSION, CREATE SYNONYM, CREATE TABLE, CREATE VIEW |
|
CREATE TYPE 7 |
CREATE TYPE, EXECUTE, EXECUTE ANY TYPE, ADMIN OPTION, GRANT OPTION |
|
RESOURCE 1,2 |
CREATE CLUSTER, CREATE PROCEDURE, CREATE SEQUENCE, CREATE TABLE, CREATE TRIGGER |
|
DBA 1,3, 4 |
All system privileges WITH ADMIN OPTION |
|
EXP_FULL_DATABASE 5 |
SELECT ANY TABLE, BACKUP ANY TABLE, INSERT, DELETE, AND UPDATE ON THE TABLES SYS.INCVID, SYS.INCFIL, AND SYS.INCEXP |
|
IMP_FULL_DATABASE 5 |
BECOME USER |
|
DELETE_CATALOG_ROLE 6 |
DELETE privileges on all dictionary packages for this role. |
|
EXECUTE_CATALOG_ROLE 6 |
EXECUTE privilege on all dictionary packages for this role. |
|
SELECT_CATALOG_ROLE 6 |
SELECT privilege on all catalog tables and views for this role. |
|
1. Created by SQL.BSQ.
2. Grantees of the RESOURCE role also receive the UNLIMITED TABLESPACE system privilege as an explicitly grant (not as part of the RESOURCE role). 3. Grantees of the DBA role also receive the UNLIMITED TABLESPACE system privilege with the ADMIN OPTION as an explicit grant (not as part of the DBA role). Therefore when the DBA role is revoked, any explicit grant of UNLIMITED TABLESPACE is also revoked. 4. Also includes the EXP_FULL_DATABASE and IMP_FULL_DATABASE roles if CATEXP.SQL has been run. 5. Created by CATEXP.SQL. 6. These roles must be granted to users who do not have the DBA role, but require access to the views and tables in the data dictionary. 7. The CREATE TYPE command is only available if the Oracle objects option is installed on your database server. |
|