| General Information |
| Purpose |
Grants the privileges needed by a user to be an administrator for OGG Integration with XStreamOut |
| Source |
$ORACLE_HOME/rdbms/admin/dbmsxstr.sql |
| First Available |
11.2.0.2 |
| Dependencies |
| DBMS_XSTREAM_ADM_INTERNAL |
|
| Security Model |
Execute is granted to the EXECUTE_CATALOG_ROLE role |
| |
GRANT_ADMIN_PRIVILEGE (new 11.2.0.3 parameters)  |
| Grants the privileges needed by a user to be an administrator for OGG integration with XStreamOut |
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); |
| TBD |
| |
| REVOKE_ADMIN_PRIVILEGE (new 11.2.0.3 parameters) |
| Revokes the privileges needed by a user to be an administrator for OGG integration with XStreamOut |
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); |
| TBD |
