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