Oracle DBMS_XSTREAM_AUTH_IVK
Version 12.1.0.1

General Information
Library Note Morgan's Library Page Footer
The Library is currently in the process of being upgraded from Oracle Database Version 11.2.0.3 to 12.1.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.
Purpose Internal package used to grant XStream and GoldenGate privileges
AUTHID CURRENT_USER
Dependencies
DBA_USERS DBMS_LOGREP_UTIL DBMS_XSTREAM_ADM_INTERNAL
DBA_XSTREAM_ADMINISTRATOR DBMS_REPCAT_COMMON_UTL DBMS_XSTREAM_ADM_UTL
DBMS_APPLY_ADM DBMS_REPCAT_DECL DBMS_XSTREAM_AUTH
DBMS_ASSERT DBMS_STREAMS_ADM PLITBLM
DBMS_GOLDENGATE_AUTH DBMS_STREAMS_ADM_UTL UTL_FILE
DBMS_LOGREP_LIB DBMS_UTILITY XSTREAM$_PRIVILEGES
Documented No
First Available 12.1.0
Other Privilege Parameter Values
DV_GOLDENGATE_ADMIN DV_XSTREAM_ADMIN XDBADMIN
Privilege Type Parameter Values
APPLY CAPTURE  
Security Model Owned by SYS with
Source {ORACLE_HOME}/rdbms/admin/prvthxstr.plb
Subprograms
 
GRANT_ADMIN_PRIVILEGE
Grants XStream administrator privileges dbms_xstream_auth_ivk.grant_admin_privilege(
grantee                   IN VARCHAR2,
privilege_type            IN VARCHAR2,
grant_select_privileges   IN BOOLEAN,
do_grants                 IN BOOLEAN,
file_name                 IN VARCHAR2,
directory_name            IN VARCHAR2,
grant_optional_privileges IN VARCHAR2);
conn sys@pdbdev as sysdba

exec dbms_xstream_auth_ivk.grant_admin_privilege('UWCLASS', 'CAPTURE', TRUE, TRUE);

SELECT *
FROM dba_xstream_administrator;

exec dbms_xstream_auth_ivk.revoke_admin_privilege('UWCLASS', 'CAPTURE', TRUE, TRUE);

SELECT *
FROM dba_xstream_administrator;
 
GRANT_ADMIN_PRIVILEGE_PDBS
Undocumented dbms_xstream_auth_ivk.grant_admin_privilege_pdbs(
grantee                   IN VARCHAR2,
privilege_type            IN VARCHAR2,
grant_select_privileges   IN BOOLEAN,
do_grants                 IN BOOLEAN,
file_name                 IN VARCHAR2,
directory_name            IN VARCHAR2,
grant_optional_privileges IN VARCHAR2,
is_ogg                    IN BOOLEAN,
canon_invoker             IN VARCHAR2,
container                 IN VARCHAR2);
exec dbms_xstream_auth_ivk.grant_admin_privilege_pdbs('UWCLASS', 'CAPTURE', TRUE, TRUE, 'x.doc', 'ORACLE_BASE', 'XDBADMIN', TRUE, 'M_IDEN', 'PDBDEV');

SELECT *
FROM dba_goldengate_privileges;

exec dbms_xstream_auth_ivk.revoke_admin_privilege_pdbs('UWCLASS', 'CAPTURE', TRUE, TRUE, 'x.txt', 'ORACLE_BASE', 'XDBADMIN', TRUE, 'M_IDEN', 'PDBDEV');

SELECT *
FROM dba_goldengate_privileges;
 
REVOKE_ADMIN_PRIVILEGE
Revokes XStream administrator privileges dbms_xstream_auth_ivk.revoke_admin_privilege(
grantee                   IN VARCHAR2,
privilege_type            IN VARCHAR2,
grant_select_privileges   IN BOOLEAN,
do_grants                 IN BOOLEAN,
file_name                 IN VARCHAR2,
directory_name            IN VARCHAR2,
grant_optional_privileges IN VARCHAR2);
See GRANT_ADMIN_PRIVILEGE Demo Above
 
REVOKE_ADMIN_PRIVILEGE_PDBS
Undocumented dbms_xstream_auth_ivk.revoke_admin_privilege_pdbs(
grantee                   IN VARCHAR2,
privilege_type            IN VARCHAR2,
grant_select_privileges   IN BOOLEAN,
do_grants                 IN BOOLEAN,
file_name                 IN VARCHAR2,
directory_name            IN VARCHAR2,
grant_optional_privileges IN VARCHAR2,
is_ogg                    IN BOOLEAN,
canon_invoker             IN VARCHAR2,
container                 IN VARCHAR2);
See GRANT_ADMIN_PRIVILEGE_PDBS Demo Above

Related Topics
DBMS_GOLDENGATE_AUTH
DBMS_STREAMS_AUTH
Packages

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2014 Daniel A. Morgan All Rights Reserved