VIEW: SYS.USER_GOLDENGATE_PRIVILEGES

Source

View Text - Preformatted

select decode(p.privilege_type, 1, 'CAPTURE',
                                2, 'APPLY',
                                3, '*'),
       decode(p.privilege_level, 0, 'NO',
                                 1, 'YES'),
       create_time
from sys.goldengate$_privileges p, user_users u
where p.username = u.username

View Text - HTML Formatted

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