Oracle DBMS_GOLDENGATE_AUTH
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
Purpose Used to grant the privileges needed by a user to be an administrator for OGG Integration with XStreamOut
AUTHID CURRENT_USER
Dependencies
DBMS_APPLY_ADM DBMS_STANDARD DBMS_XSTREAM_ADM_INTERNAL
DBMS_LOGREP_UTIL DBMS_UTILITY DBMS_XSTREAM_AUTH_IVK
Documented Yes
First Available 11.2.0.2
Security Model Owned by SYS with EXECUTE granted to the EXECUTE_CATALOG_ROLE role
Source $ORACLE_HOME/rdbms/admin/dbmsxstr.sql
Subprograms
 
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');
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');
exec dbms_goldengate_auth.revoke_admin_privilege('ggadmin', 'APPLY', TRUE);

Related Topics
DBMS_GOLDENGATE_ADM
DBMS_GOLDENGATE_ADM_INTERNAL
DBMS_GOLDENGATE_EXP
DBMS_GOLDENGATE_IMP
DBMS_XSTREAM_ADM
DBMS_XSTREAM_GG
Dynamic Performance Views
Packages
What's New In 12cR1
What's New In 12cR2

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2017 Daniel A. Morgan All Rights Reserved