SQL> show user
USER is "SYS"
SQL> select * from dba_sys_privs where GRANTEE='CONNECT';

GRANTEE                PRIVILEGE                ADM
------------------------------ ---------------------------------------- ---
CONNECT                CREATE SESSION                NO

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> show user
USER is "PDAHD"
SQL> select * from user_role_privs;

USERNAME               GRANTED_ROLE              ADM DEF OS_
------------------------------ ------------------------------ --- --- ---
PDAHD                   CONNECT                  NO  YES NO
PDAHD                   RESOURCE               NO  YES NO

SQL> select * from session_privs;

PRIVILEGE
----------------------------------------
CREATE SESSION
UNLIMITED TABLESPACE
CREATE TABLE
CREATE CLUSTER
CREATE SEQUENCE
CREATE DATABASE LINK
CREATE PUBLIC DATABASE LINK
CREATE PROCEDURE
CREATE TRIGGER
CREATE TYPE
CREATE OPERATOR
CREATE INDEXTYPE

12 rows selected.