Are you
prepared for the release of Oracle Database
18c ... the first autonomous database? We are here at the Library. It is
time for DBAs to stop fighting robots with their fingers and losing ...
time to start using our intelligence and winning.
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');
