SESSION_PRIVS Dictionary View

SESSION_PRIVS dictionary view contains current system privileges available in the user session.

SQL> select * from session_privs;

PRIVILEGE
---------------------------------------
ALTER SYSTEM
AUDIT SYSTEM
CREATE SESSION
ALTER SESSION
RESTRICTED SESSION
CREATE TABLESPACE
ALTER TABLESPACE
MANAGE TABLESPACE
DROP TABLESPACE
UNLIMITED TABLESPACE
CREATE USER