Oracle | DBMS_XSTREAM_AUTH

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	GRANT_ADMIN_PRIVILEGE_PDBS	REVOKE_ADMIN_PRIVILEGE_INT
GRANT_ADMIN_PRIVILEGE	REVOKE_ADMIN_PRIVILEGE	REVOKE_ADMIN_PRIVILEGE_PDBS
GRANT_ADMIN_PRIVILEGE_INT

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