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