Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
PDF · Mobi · ePub


ALL_GOLDENGATE_PRIVILEGES displays details about Oracle GoldenGate privileges for the user.

Oracle GoldenGate privileges are granted using the DBMS_GOLDENGATE_AUTH package.

Related Views

Column Datatype NULL Description
USERNAME VARCHAR2(128) NOT NULL Name of the user that is granted the privilege
PRIVILEGE_TYPE VARCHAR2(7)   Type of privilege granted:


  • *: Both APPLY and CAPTURE

GRANT_SELECT_PRIVILEGES VARCHAR2(3)   Shows whether the set of privileges granted to the administrator make the administrator a full privilege administrator or a minimum privilege administrator:
  • YES: The administrator has the SELECT_CATALOG_ROLE role and other privileges, is considered a full privilege administrator, and can manage any Oracle GoldenGate configuration.

  • NO: The administrator is considered a minimum privilege administrator, and can only manage Oracle GoldenGate configurations where the apply_user or capture_user (based on the PRIVILEGE_TYPE column) matches the username.

CREATE_TIME TIMESTAMP(6)   Timestamp for the granted privilege

See Also: