1、CONNECT privilegs
SQL> select * from dba_sys_privs where grantee='CONNECT'; GRANTEE PRIVILEGE ADM ------------------------------ ---------------------------------------- --- CONNECT CREATE SESSION NO
2、RESOURCE privilegs
SQL> select * from dba_sys_privs where grantee='RESOURCE'; GRANTEE PRIVILEGE ADM ------------------------------ ---------------------------------------- --- RESOURCE CREATE TRIGGER NO RESOURCE CREATE SEQUENCE NO RESOURCE CREATE TYPE NO RESOURCE CREATE PROCEDURE NO RESOURCE CREATE CLUSTER NO RESOURCE CREATE OPERATOR NO RESOURCE CREATE INDEXTYPE NO RESOURCE CREATE TABLE NO 8 rows selected. SQL>
3、RECOVERY_CATALOG_OWNER privilegs
SQL> select * from dba_sys_privs where grantee='RECOVERY_CATALOG_OWNER'; GRANTEE PRIVILEGE ADM ------------------------------ ---------------------------------------- --- RECOVERY_CATALOG_OWNER CREATE SYNONYM NO RECOVERY_CATALOG_OWNER CREATE CLUSTER NO RECOVERY_CATALOG_OWNER ALTER SESSION NO RECOVERY_CATALOG_OWNER CREATE DATABASE LINK NO RECOVERY_CATALOG_OWNER CREATE PROCEDURE NO RECOVERY_CATALOG_OWNER CREATE SEQUENCE NO RECOVERY_CATALOG_OWNER CREATE TABLE NO RECOVERY_CATALOG_OWNER CREATE SESSION NO RECOVERY_CATALOG_OWNER CREATE TYPE NO RECOVERY_CATALOG_OWNER CREATE VIEW NO RECOVERY_CATALOG_OWNER CREATE TRIGGER NO 11 rows selected. SQL>