VIEW: SYS.DBA_UNUSED_USERPRIVS

Source

View Text - Preformatted

SELECT UNIQUE CAPTURE, USERNAME, ROLENAME, USER_PRIV, OBJECT_NAME, OPTION$
FROM SYS.DBA_UNUSED_PRIVS WHERE USER_PRIV IS NOT NULL

View Text - HTML Formatted

SELECT UNIQUE CAPTURE
, USERNAME
, ROLENAME
, USER_PRIV
, OBJECT_NAME
, OPTION$ FROM SYS.DBA_UNUSED_PRIVS
WHERE USER_PRIV IS NOT NULL