VIEW: SYS.DBA_USED_PUBPRIVS

Source

View Text - Preformatted

SELECT UNIQUE CAPTURE, SEQUENCE, OS_USER, USERHOST, MODULE, USERNAME, SYS_PRIV, OBJ_PRIV, OBJECT_OWNER, OBJECT_NAME, OBJECT_TYPE, OPTION$ FROM SYS.DBA_USED_PRIVS WHERE 'PUBLIC' in (select column_value from table(path))

View Text - HTML Formatted

SELECT UNIQUE CAPTURE
, SEQUENCE
, OS_USER
, USERHOST
, MODULE
, USERNAME
, SYS_PRIV
, OBJ_PRIV
, OBJECT_OWNER
, OBJECT_NAME
, OBJECT_TYPE
, OPTION$
FROM SYS.DBA_USED_PRIVS
WHERE 'PUBLIC' IN (SELECT COLUMN_VALUE
FROM TABLE(PATH))