DBA Data[Home] [Help]
Skip to content

VIEW: SYS.DBA_USED_SYSPRIVS

Source

View Text - Preformatted

SELECT UNIQUE CAPTURE, SEQUENCE, OS_USER, USERHOST, MODULE, USERNAME, USED_ROLE, SYS_PRIV, OPTION$ FROM SYS.DBA_USED_PRIVS WHERE SYS_PRIV IS NOT NULL
View Text - HTML Formatted

SELECT UNIQUE CAPTURE
, SEQUENCE
, OS_USER
, USERHOST
, MODULE
, USERNAME
, USED_ROLE
, SYS_PRIV
, OPTION$
FROM SYS.DBA_USED_PRIVS
WHERE SYS_PRIV IS NOT NULL