VIEW: SYS.DBA_UNUSED_OBJPRIVS

Source

View Text - Preformatted

SELECT UNIQUE CAPTURE, USERNAME, ROLENAME, OBJ_PRIV, OBJECT_OWNER, OBJECT_NAME, OBJECT_TYPE, COLUMN_NAME , OPTION$
FROM SYS.DBA_UNUSED_PRIVS
WHERE OBJ_PRIV IS NOT NULL

View Text - HTML Formatted

SELECT UNIQUE CAPTURE
, USERNAME
, ROLENAME
, OBJ_PRIV
, OBJECT_OWNER
, OBJECT_NAME
, OBJECT_TYPE
, COLUMN_NAME
, OPTION$ FROM SYS.DBA_UNUSED_PRIVS WHERE OBJ_PRIV IS NOT NULL