VIEW: SYS.SESSION_PRIVS

Source

View Text - Preformatted

select spm.name
from sys.v$enabledprivs ep, system_privilege_map spm
where spm.privilege = ep.priv_number

View Text - HTML Formatted

SELECT SPM.NAME FROM SYS.V$ENABLEDPRIVS EP
, SYSTEM_PRIVILEGE_MAP SPM WHERE SPM.PRIVILEGE = EP.PRIV_NUMBER