Oracle DBMS_GOLDENGATE_AUTH
Version 19.3

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
First Available 11.2.0.2
Security Model Owned by SYS with no privileges granted
Source $ORACLE_HOME/rdbms/admin/dbmsgg.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');
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);

Related Topics
Built-in Functions
Built-in Packages
DBMS_GOLDENGATE_ADM
DBMS_GOLDENGATE_ADM_INTERNAL
DBMS_GOLDENGATE_EXP
DBMS_GOLDENGATE_IMP
DBMS_XSTREAM_ADM
DBMS_XSTREAM_GG
DBMS_XSTREAM_GG_INTERNAL
Dynamic Performance Views
What's New In 18c
What's New In 19c

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-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx