DBA Data[Home] [Help]

VIEW: SYS.DBA_PRIV_CAPTURES

Source

View Text - Preformatted

SELECT name, description,
decode(type, 1, 'DATABASE', 2, 'ROLE', 3, 'CONTEXT', 4, 'ROLE_AND_CONTEXT') type, decode(enabled, 1, 'Y', 0, 'N') enabled, roles, context
FROM sys.priv_capture$
View Text - HTML Formatted

SELECT NAME
, DESCRIPTION
, DECODE(TYPE
, 1
, 'DATABASE'
, 2
, 'ROLE'
, 3
, 'CONTEXT'
, 4
, 'ROLE_AND_CONTEXT') TYPE
, DECODE(ENABLED
, 1
, 'Y'
, 0
, 'N') ENABLED
, ROLES
, CONTEXT FROM SYS.PRIV_CAPTURE$