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
Utility package supporting heterogeneous streams replication and GoldenGate
AUTHID
DEFINER
Dependencies
ALL_USERS
DBMS_LOGREP_LIB
DBMS_XSTREAM_GG_ADM
ANYDATA
DBMS_LOGREP_UTIL
DBMS_XSTREAM_UTL_IVK
DBA_APPLY
DBMS_LOGREP_UTIL_INVOK
PROPS$
DBA_CAPTURE
DBMS_RULE_ADM
STREAMS$_APPLY_MILESTONE
DBA_GOLDENGATE_RULES
DBMS_STANDARD
STREAMS$_APPLY_PROCESS
DBA_STREAMS_RULES
DBMS_STREAMS_ADM
STREAMS$_CAPTURE_PROCESS
DBA_XSTREAM_RULES
DBMS_STREAMS_ADM_UTL
STREAMS$_CAPTURE_SERVER
DBMS_APPLY_ADM
DBMS_STREAMS_DECL
XSTREAM$_PRIVILEGES
DBMS_APPLY_ADM_INTERNAL
DBMS_STREAMS_LCR_INT
XSTREAM$_SERVER
DBMS_AQADM
DBMS_SYSTEM
XSTREAM$_SUBSET_RULES
DBMS_ASSERT
DBMS_UTILITY
XSTREAM$_SYSGEN_OBJS
DBMS_CAPTURE_ADM
DBMS_XSTREAM_ADM
_DBA_GGXSTREAM_INBOUND
DBMS_CAPTURE_ADM_INTERNAL
DBMS_XSTREAM_AUTH
_DBA_GGXSTREAM_OUTBOUND
DBMS_CAPTURE_ADM_IVK
DBMS_XSTREAM_AUTH_IVK
Documented
No
First Available
11.2
Security Model
Owned by SYS with EXECUTE granted to the EXECUTE_CATALOG_ROLE role.
dbms_xstream_adm_utl.alter_outbound(
canon_svr_name IN VARCHAR2
canon_capture IN VARCHAR2
canon_invoker IN VARCHAR2
oldest_scn IN BINARY_INTEGER
processed_lwm_scn IN BINARY_INTEGER
flags IN BINARY_INTEGER);
dbms_xstream_adm_utl.create_xout_capture(
queue_name IN VARCHAR2,
canon_capture IN VARCHAR2,
canon_invoker IN VARCHAR2,
source_database IN VARCHAR2,
capture_user IN VARCHAR2,
enable_procedure IN BOOLEAN,
source_root_name IN VARCHAR2);
dbms_xstream_adm_utl.del_subset_rules(
canon_server_name IN VARCHAR2,
canon_ins_rule IN VARCHAR2,
canon_upd_rule IN VARCHAR2,
canon_del_rule IN VARCHAR2,
canon_rules_owner IN VARCHAR2);
dbms_xstream_adm_utl.get_cap_n_queue(
canon_server_name IN VARCHAR2,
canon_capture OUT VARCHAR2,
canon_cap_src_db OUT VARCHAR2,
canon_cap_src_root OUT VARCHAR2,
canon_queue_owner OUT VARCHAR2,
canon_queue_name OUT VARCHAR2,
is_outbound IN BOOLEAN);
dbms_xstream_adm_utl.get_local_capture(
canon_qowner IN VARCHAR2,
canon_qname IN VARCHAR2,
canon_capture IN OUT VARCHAR2,
canon_cap_src_db IN OUT VARCHAR2);
dbms_xstream_adm_utl.get_procedure_rules(
canon_strms_name IN VARCHAR2,
streams_type IN VARCHAR2,
inclusion_rule IN BOOLEAN,
rule_list_out OUT dbms_utility.uncl_array,
rule_cnt OUT NUMBER);
dbms_xstream_adm_utl.get_streams_rule(
canon_strms_name IN VARCHAR2,
streams_type IN VARCHAR2,
table_cnt IN NUMBER,
canon_tab_owners IN dbms_utility.name_array,
canon_tab_names IN dbms_utility.name_array,
schema_cnt IN NUMBER,
canon_schemas IN dbms_utility.name_array,
inclusion_rule IN BOOLEAN,
rule_list OUT dbms_utility.uncl_array,
rule_cnt OUT NUMBER,
include_dml IN BOOLEAN,
include_ddl IN BOOLEAN,
source_db IN VARCHAR2,
source_root IN VARCHAR2);
dbms_xstream_adm_utl.has_table_rule(
canon_table_owner IN VARCHAR2,
canon_table_name IN VARCHAR2,
canon_strm_name IN VARCHAR2,
streams_type IN VARCHAR2)
RETURN BOOLEAN;
dbms_xstream_adm_utl.ins_gen_obj(
canon_server_name IN VARCHAR2,
canon_object_owner IN VARCHAR2,
canon_object_name IN VARCHAR2,
object_type IN VARCHAR2);
dbms_xstream_adm_utl.ins_subset_rules(
canon_server_name IN VARCHAR2,
ins_rule IN VARCHAR2,
upd_rule IN VARCHAR2,
del_rule IN VARCHAR2,
canon_invoker IN VARCHAR2);
DECLARE
b BOOLEAN;
BEGIN
IF dbms_xstream_adm_utl.is_gg_xstream_for_streams THEN
dbms_output.put_line('TRUE');
ELSE
dbms_output.put_line('FALSE');
END IF;
END;
/
dbms_xstream_adm_utl.remove_gen_rule(
rule_name IN VARCHAR2,
streams_type IN VARCHAR2,
streams_name IN VARCHAR2,
canon_invoker IN VARCHAR2,
inclusion_rule IN BOOLEAN);
dbms_xstream_adm_utl.valid_subset_rules(
canon_svr_name IN VARCHAR2,
canon_ins_rule IN VARCHAR2,
canon_upd_rule IN VARCHAR2,
canon_del_rule IN VARCHAR2,
canon_rules_owner IN VARCHAR2)
RETURN BOOLEAN;