Oracle | DBMS_GOLDENGATE

Oracle DBMS_GOLDENGATE_AUTH Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Used to grant the privileges needed by a user to be an administrator for OGG Integration with XStreamOut

AUTHID CURRENT_USER

Dependencies

ALL_USERS	DBMS_LOGREP_UTIL	DBMS_XSTREAM_ADM_INTERNAL
DBMS_APPLY_ADM	DBMS_STANDARD	DBMS_XSTREAM_AUTH_IVK
DBMS_ASSERT	DBMS_UTILITY

Documented Yes: Packages and Types Reference

First Available 11.2

Security Model Owned by SYS with no privileges granted

Source $ORACLE_HOME/rdbms/admin/dbmsgg.sql

Subprograms

GRANT_ADMIN_PRIVILEGE

REVOKE_ADMIN_PRIVILEGE

GRANT_ADMIN_PRIVILEGE

Grants the privileges needed by a user to be an administrator for OGG integration with XStreamOut

Privilege Types can be CAPTURE, APPLY, or * (meaning both) dbms_goldengate_auth.grant_admin_privilege( grantee IN VARCHAR2, privilege_type IN VARCHAR2 DEFAULT '*', grant_select_privileges IN BOOLEAN DEFAULT FALSE, do_grants IN BOOLEAN DEFAULT TRUE, file_name IN VARCHAR2 DEFAULT NULL, directory_name IN VARCHAR2 DEFAULT NULL, grant_optional_privileges IN VARCHAR2 DEFAULT NULL, container IN VARCHAR2 DEFAULT 'CURRENT'); PRAGMA SUPPLEMENTAL_LOG_DATA(grant_admin_privilege, MANUAL_WITH_COMMIT);

exec dbms_goldengate_auth.grant_admin_privilege('ggadmin', 'CAPTURE', TRUE);

REVOKE_ADMIN_PRIVILEGE

Revokes the privileges needed by a user to be an administrator for OGG integration with XStreamOut

Privilege Types can be CAPTURE, APPLY, or * (meaning both) dbms_goldengate_auth.revoke_admin_privilege( grantee IN VARCHAR2, privilege_type IN VARCHAR2 DEFAULT '*', revoke_select_privileges IN BOOLEAN DEFAULT FALSE, do_revokes IN BOOLEAN DEFAULT TRUE, file_name IN VARCHAR2 DEFAULT NULL, directory_name IN VARCHAR2 DEFAULT NULL, revoke_optional_privileges IN VARCHAR2 DEFAULT NULL, container IN VARCHAR2 DEFAULT 'CURRENT'); PRAGMA SUPPLEMENTAL_LOG_DATA(revoke_admin_privilege, MANUAL_WITH_COMMIT);

exec dbms_goldengate_auth.revoke_admin_privilege('ggadmin', 'APPLY', TRUE);