Oracle | DBMS_XSTREAM_ADM

Oracle DBMS_XSTREAM_ADM_INTERNAL 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 Xstreams Heterogeneous Replication Administrative Utilities

AUTHID DEFINER

Dependencies

ALL_USERS	DBMS_LOGREP_UTIL	DUAL
DBA_EDITIONS	DBMS_STANDARD	GG$_PACKAGE_MAPPING
DBA_GG_SUPPORTED_PACKAGES	DBMS_STREAMS_ADM	GLOBAL_NAME
DBA_TAB_PRIVS	DBMS_STREAMS_ADM_UTL	GOLDENGATE$_CONTAINER_RULES
DBMS_APPLY_ADM_INTERNAL	DBMS_UTILITY	GOLDENGATE$_PRIVILEGES
DBMS_ASSERT	DBMS_XSTREAM_ADM	PLITBLM
DBMS_CAPTURE_ADM_INTERNAL	DBMS_XSTREAM_AUTH_IVK	REPL$_PROCESS_EVENTS
DBMS_GOLDENGATE_AUTH	DBMS_XSTREAM_GG_ADM	RULE_ID_SEQ$
DBMS_LOGREP_LIB	DBMS_XSTREAM_UTL_IVK	XSTREAM$_SERVER

Documented No

First Available 11.2

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/prvthxstr.plb

Subprograms

ADD_CONTAINER_RULE	GET_OPTIONAL_PRIVILEGES	REMOVE_CONTAINER_RULE_BY_ID
ADD_GOLDENGATE_PRIVILEGE	INS_XSERVER	REMOVE_GOLDENGATE_PRIVILEGE
CONVERT_POSITION_INTERNAL	POPULATE_SCRIPT_ARRAY	UPDATE_GOLDENGATE_PRIVILEGE
DELETE_REPLICATION_EVENTS	REMOVE_CONTAINER_RULE	UPDATE_XSERVER_CONNECT_USER

ADD_CONTAINER_RULE

Add a new container role dbms_xstream_adm_internal.add_container_rule( capture_name IN VARCHAR2, canon_filter_rule IN VARCHAR2, inclusion_rule IN BOOLEAN, escale_char IN CHAR, wildcard_flag IN BOOLEAN);

TBD

ADD_GOLDENGATE_PRIVILEGE

Add a new GoldenGate privilege dbms_xstream_adm_internal.add_goldengate_privilege( canon_grantee IN VARCHAR2, canon_privilege_type IN NUMBER, canon_privilege_level IN NUMBER);

TBD

CONVERT_POSITION_INTERNAL

Undocumented dbms_xstream_adm_internal.convert_position_internal( position IN RAW, version IN BINARY_INTEGER, newposition OUT RAW)

TBD

DELETE_REPLICATION_EVENTS

Delete an XSTREAM replication event dbms_xstream_adm_internal.delete replication_events( streams_name IN VARCHAR2, streams_type IN VARCHAR2, process_type IN VARCHAR2, event_name IN VARCHAR2, include_error IN BOOLEAN, event_time_in IN TIMESTAMP);

TBD

GET_OPTIONAL_PRIVILEGES

Undocumented dbms_xstream_adm_internal.get_optional_privileges( optional_privileges IN VARCHAR2, privilege_table OUT dbms_utility.name_array, procrep_packages OUT dbms_utility.lname_array, procrep OUT BOOLEAN, procrep_allowed IN BOOLEAN, isogg IN BOOLEAN) RETURN NUMBER;

TBD

INS_XSERVER

Undocumented dbms_xstream_adm_internal.ins_xserver( canon_server_name IN VARCHAR2, canon_app_src_db IN VARCHAR2, canon_queue_owner IN VARCHAR2, canon_queue_name IN VARCHAR2, canon_capture_name IN VARCHAR2, canon_cap_src_db IN VARCHAR2, usr_comment IN VARCHAR2, flags IN NUMBER);

TBD

POPULATE_SCRIPT_ARRAY

Undocumented dbms_xstream_adm_internal.populate_script_array( is_grant IN BOOLEAN, script IN OUT dbms_xstream_auth_ivk.script_t, canon_grantee IN VARCHAR2, canon_privilege_type IN VARCHAR2, select_privilegeS IN BOOLEAN, optional_privilegeS IN VARCHAR2, canon_container IN VARCHAR2);

TBD

REMOVE_CONTAINER_RULE

Remove a container capture rule by the filter rule_name dbms_xstream_adm_internal.remove_container_rule( capture_name IN VARCHAR2, canon_filter_rule IN VARCHAR2, inclusion_rule IN BOOLEAN);

TBD

REMOVE_CONTAINER_RULE_BY_ID

Remove a container capture rule by its rule_id dbms_xstream_adm_internal.remove_container_rule_by_id( capture_name IN VARCHAR2, rule_id IN NUMBER);

TBD

REMOVE_GOLDENGATE_PRIVILEGE

Revoke a GoldenGate privilege dbms_xstream_adm_internal.remove_goldengate_privilege( canon_grantee IN VARCHAR2, canon_privilege_type IN NUMBER, canon_privilege_level IN NUMBER);

TBD

UPDATE_GOLDENGATE_PRIVILEGE

Modify a GoldenGate privilege dbms_xstream_adm_internal.update_goldengate_privilege( grantee IN VARCHAR2, optional_priv IN VARCHAR2, canon_invoker IN VARCHAR2, allpdbs IN NUMBER);

TBD

UPDATE_XSERVER_CONNECT_USER

Undocumented dbms_xstream_adm_internal.update_xserver_connect_user( canon_server_name IN VARCHAR2, connect_user IN VARCHAR2);

TBD