sql1>select sid,serial#,username from v$session where sid=(select sys_context('userenv','sid') from dual);
SID SERIAL# USERNAME
---------- ---------- ----------
1457 3 JF_ISU
04:43:18 sql1>select * from user_role_privs;
USERNAME GRANTED_ROLE ADM DEF OS_
------------------------------ ------------------------------ --- --- ---
JF_ISU CONNECT NO YES NO
JF_ISU RESOURCE NO YES NO
04:43:24 sql1>
04:43:25 sql1>select * from role_sys_privs;
ROLE PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
CONNECT CREATE SESSION NO
RESOURCE CREATE CLUSTER NO
RESOURCE CREATE SEQUENCE NO
RESOURCE CREATE TRIGGER NO
RESOURCE CREATE TABLE NO
RESOURCE CREATE PROCEDURE NO
RESOURCE CREATE TYPE NO
RESOURCE CREATE OPERATOR NO
RESOURCE CREATE INDEXTYPE NO
9 rows selected.
04:43:34 sql1>
04:43:35 sql1>select * from user_sys_privs;
USERNAME PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
JF_ISU SELECT ANY DICTIONARY NO
JF_ISU CREATE SEQUENCE NO
JF_ISU DEBUG CONNECT SESSION NO
JF_ISU CREATE TYPE NO
JF_ISU CREATE VIEW NO
JF_ISU SELECT ANY TABLE NO
JF_ISU CREATE DATABASE LINK NO
JF_ISU CREATE TABLE NO
JF_ISU UNLIMITED TABLESPACE NO
JF_ISU CREATE TRIGGER NO
JF_ISU CREATE SYNONYM NO
JF_ISU DEBUG ANY PROCEDURE NO
JF_ISU SELECT ANY SEQUENCE NO
13 rows selected.
04:43:43 sql1>