VIEW: SYS.ALL_GOLDENGATE_PRIVILEGES

Source

View Text - Preformatted

(select gp."USERNAME",gp."PRIVILEGE_TYPE",gp."GRANT_SELECT_PRIVILEGES",gp."CREATE_TIME"
  from DBA_GOLDENGATE_PRIVILEGES gp, sys.user$ u, dba_role_privs rp
  where ((gp.username = u.name) and  (u.user# = userenv('SCHEMAID')))
union
select gp."USERNAME",gp."PRIVILEGE_TYPE",gp."GRANT_SELECT_PRIVILEGES",gp."CREATE_TIME"
  from DBA_GOLDENGATE_PRIVILEGES gp, sys.user$ u, dba_role_privs rp
  where (u.name = rp.grantee
        and rp.granted_role = 'SELECT_CATALOG_ROLE'
        and u.user# = userenv('SCHEMAID')))

View Text - HTML Formatted

(SELECT GP."USERNAME"
, GP."PRIVILEGE_TYPE"
, GP."GRANT_SELECT_PRIVILEGES"
, GP."CREATE_TIME"
FROM DBA_GOLDENGATE_PRIVILEGES GP
, SYS.USER$ U
, DBA_ROLE_PRIVS RP
WHERE ((GP.USERNAME = U.NAME)
AND (U.USER# = USERENV('SCHEMAID'))) UNION SELECT GP."USERNAME"
, GP."PRIVILEGE_TYPE"
, GP."GRANT_SELECT_PRIVILEGES"
, GP."CREATE_TIME"
FROM DBA_GOLDENGATE_PRIVILEGES GP
, SYS.USER$ U
, DBA_ROLE_PRIVS RP
WHERE (U.NAME = RP.GRANTEE
AND RP.GRANTED_ROLE = 'SELECT_CATALOG_ROLE'
AND U.USER# = USERENV('SCHEMAID')))