The Library is currently in the process of being upgraded from Oracle Database Version 12.1.0.2 to 12.2.0.1.
Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs,
and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.
Also important ... there are rumors on the web about SPARC and Solaris being discontinued. Welcome to the age of fake news.
There is absolutely not a byte of truth to these irresponsible rumors.
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');
