Oracle DBMS_XSTREAM_AUTH_IVK
Version 21c

General Information
Library Note Morgan's Library Page Header
ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.
Purpose Internal package used to grant XStream and GoldenGate privileges
AUTHID CURRENT_USER
Dependencies
ALL_USERS DBMS_LOGREP_LIB DBMS_XSTREAM_ADM_INTERNAL
DBA_GOLDENGATE_PRIVILEGES DBMS_LOGREP_UTIL DBMS_XSTREAM_ADM_UTL
DBA_XSTREAM_ADMINISTRATOR DBMS_STANDARD DBMS_XSTREAM_AUTH
DBMS_APPLY_ADM DBMS_STREAMS_ADM PLITBLM
DBMS_ASSERT DBMS_STREAMS_ADM_UTL UTL_FILE
DBMS_GOLDENGATE_AUTH DBMS_UTILITY XSTREAM$_PRIVILEGES
Documented No
First Available 12.1
Other Privilege Parameter Values
DV_GOLDENGATE_ADMIN DV_XSTREAM_ADMIN XDBADMIN
Privilege Type Parameter Values
APPLY CAPTURE  
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/prvthxstr.plb
Subprograms
 
CONSTRUCT_SQL_T
Populates and returns a varray of type dbms_xstream_auth_ivk.sql_t dbms_xstream_auth_ivk.construct_sql_t(
str1  IN VARCHAR2,
str2  IN VARCHAR2,
str3  IN VARCHAR2,
str4  IN VARCHAR2,
str5  IN VARCHAR2,
str6  IN VARCHAR2,
str7  IN VARCHAR2,
str8  IN VARCHAR2,
str9  IN VARCHAR2,
str10 IN VARCHAR2)
RETURN dbms_xstream_auth_ivk.sql_t;
DECLARE
 sql_t_arr dbms_xstream_auth_ivk.sql_t;
BEGIN
  sql_t_arr := dbms_xstream_auth_ivk.construct_sql_t('A', 'B', 'C', 'Dan', 'E', 'F', 'G', 'H', 'I', 'Morgan');
  dbms_output.put_line(sql_t_arr(4) || ' ' || sql_t_arr(10));
END;
/
 
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,
canon_container           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_INT
Grant XStream Admin Privileges dbms_xstream_auth_ivk.grant_admin_privilege_int(
grantee                   IN VARCHAR2,
privilege_type            IN VARCHAR2,
grant_select_privileges   IN BOOLEAN,
do_grants                 IN BOOLEAN,
file_name                 IN VARCHAR2,
direcdtory_name           IN VARCHAR2,
grant_optional_privileges IN VARCHAR2,
canon_container           IN VARCHAR2)
TBD
 
GRANT_ADMIN_PRIVILEGE_PDBS
Grant XStream Admin Privileges for a PDB 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,
canon_container           IN VARCHAR2);
See GRANT_ADMIN_PRIVILEGE Demo Above
 
REVOKE_ADMIN_PRIVILEGE_INT
Revoke XStream Admin Privileges dbms_xstream_auth_ivk.revoke_adm_privilege_int(
grantee                    IN VARCHAR2,
privilege_type             IN VARCHAR2,
revoke_select_privileges   IN BOOLEAN,
do_revokes                 IN BOOLEAN,
file_name                  IN VARCHAR2,
directory_name             IN VARCHAR2,
revoke_optional_privileges IN VARCHAR2,
canon_container            IN VARCHAR2);
TBD
 
REVOKE_ADMIN_PRIVILEGE_PDBS
Revoke XStream Admin Privileges for a PDB 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
Built-in Functions
Built-in Packages
DBMS_GOLDENGATE_AUTH
DBMS_STREAMS_AUTH
DBMS_XSTREAM_ADM
DBMS_XSTREAM_ADM_UTL
DBMS_XSTREAM_AUTH
DBMS_XSTREAM_UTL_IVK
What's New In 21c
What's New In 23c

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-2023 Daniel A. Morgan All Rights Reserved
  DBSecWorx