DBA Data[Home] [Help]

VIEW: SYS.DBA_GOLDENGATE_PRIVILEGES

Source

View Text - Preformatted

select username,
       decode(privilege_type, 1, 'CAPTURE',
                              2, 'APPLY',
                              3, '*'),
       decode(privilege_level, 0, 'NO',
                               1, 'YES'),
       create_time
from sys.goldengate$_privileges
View Text - HTML Formatted

SELECT USERNAME
, DECODE(PRIVILEGE_TYPE
, 1
, 'CAPTURE'
, 2
, 'APPLY'
, 3
, '*')
, DECODE(PRIVILEGE_LEVEL
, 0
, 'NO'
, 1
, 'YES')
, CREATE_TIME FROM SYS.GOLDENGATE$_PRIVILEGES