Oracle DBMS_XSTREAM_ADM

Oracle DBMS_XSTREAM_ADM_INTERNAL Version 19c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

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_RULEe	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