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
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;
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);
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)
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);
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);
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);
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);