DBA Data[Home] [Help]

VIEW: SYS.DBA_UNUSED_OBJPRIVS_PATH

Source

View Text - Preformatted

SELECT CAPTURE, USERNAME, ROLENAME, OBJ_PRIV, OBJECT_OWNER, OBJECT_NAME, OBJECT_TYPE, COLUMN_NAME, OPTION$, PATH
FROM SYS.DBA_UNUSED_PRIVS
WHERE OBJ_PRIV IS NOT NULL
View Text - HTML Formatted

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