SESSION_PRIVS

SESSION_PRIVS describes the privileges that are currently available to the user.

Column	Datatype	NULL	Description
PRIVILEGE	VARCHAR2(40)	NOT NULL	Name of the privilege

Note:

1.

select * from SESSION_PRIVS;

PRIVILEGE

CREATE SESSION

Oracle data dictionary views

Oracle dynamic performance views

More Oracle DBA tips, please visit Oracle DBA Tips