Oracle | DBMS_GOLDENGATE

Oracle DBMS_GOLDENGATE_AUTH Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

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);