USERNAME

VARCHAR2(128)

NOT NULL

Name of the user that is granted the privilege

PRIVILEGE_TYPE

VARCHAR2(7)

Type of privilege granted:

• APPLY

• CAPTURE

• *: 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