VIEW: SYS.DBA_USED_OBJPRIVS

Source

View Text - Preformatted

SELECT UNIQUE CAPTURE, SEQUENCE, OS_USER, USERHOST, MODULE, USERNAME, USED_ROLE, OBJ_PRIV, OBJECT_OWNER, OBJECT_NAME, OBJECT_TYPE, COLUMN_NAME,OPTION$ FROM SYS.DBA_USED_PRIVS WHERE OBJ_PRIV IS NOT NULL

View Text - HTML Formatted

SELECT UNIQUE CAPTURE
, SEQUENCE
, OS_USER
, USERHOST
, MODULE
, USERNAME
, USED_ROLE
, OBJ_PRIV
, OBJECT_OWNER
, OBJECT_NAME
, OBJECT_TYPE
, COLUMN_NAME
, OPTION$
FROM SYS.DBA_USED_PRIVS
WHERE OBJ_PRIV IS NOT NULL