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 Support Utilities
AUTHID
CURRENT_USER
Dependencies
ALL_CAPTURE
DBMS_LOCK
DBMS_UTILITY
ALL_XSTREAM_OUTBOUND
DBMS_LOGREP_UTIL
DBMS_XSTREAM_ADM
DBA_APPLY
DBMS_LOGREP_UTIL_INVOK
DBMS_XSTREAM_ADM_INTERNAL
DBA_CAPTURE
DBMS_RULE_ADM
DBMS_XSTREAM_ADM_UTL
DBA_REGISTERED_ARCHIVED_LOG
DBMS_STANDARD
DBMS_XSTREAM_GG_ADM
DBMS_APPLY_ADM
DBMS_STREAMS_ADM
DBMS_XSTREAM_GG_INTERNAL
DBMS_APPLY_ADM_INTERNAL
DBMS_STREAMS_ADM_IVK
GLOBAL_NAME
DBMS_ASSERT
DBMS_STREAMS_ADM_UTL
GV$ARCHIVED_LOG
DBMS_CAPTURE_ADM
DBMS_STREAMS_ADM_UTL_INVOK
PLITBLM
DBMS_CAPTURE_ADM_INTERNAL
DBMS_STREAMS_DECL
TIMESTAMP_TO_SCN
DBMS_FLASHBACK
DBMS_STREAMS_RPC
Documented
No
First Available
11.2
Security Model
Owned by SYS with EXECUTE granted to the EXECUTE_CATALOG_ROLE
dbms_xstream_utl_ivk.add_outbound(
server_name IN VARCHAR2,
queue_name IN VARCHAR2,
source_database IN VARCHAR2,
table_names IN dbms_utility.uncl_array,
schema_names IN dbms_utility.uncl_array,
connect_user IN VARCHAR2,
comment IN VARCHAR2,
committed_data_only IN BOOLEAN,
capture_name IN VARCHAR2,
start_scn IN NUMBER,
start_time IN TIMESTAMP,
include_dml IN BOOLEAN,
include_ddl IN BOOLEAN,
source_root_name IN VARCHAR2,
lcrid_version IN NUMBER);
TBD
Overload 2
dbms_xstream_utl_ivk.add_outbound(
server_name IN VARCHAR2,
queue_name IN VARCHAR2,
source_database IN VARCHAR2,
table_names IN VARCHAR2,
schema_names IN VARCHAR2,
connect_user IN VARCHAR2,
comment IN VARCHAR2,
committed_data_only IN BOOLEAN,
capture_name IN VARCHAR2,
start_scn IN NUMBER,
start_time IN TIMESTAMP,
include_dml IN BOOLEAN,
include_ddl IN BOOLEAN,
source_root_name IN VARCHAR2,
lcrid_version IN NUMBER);
dbms_xstream_utl_ivk.add_subset_outbound_rules(
server_name IN VARCHAR2,
table_name IN VARCHAR2,
condition IN VARCHAR2,
column_list IN dbms_utility.lname_array,
keep IN BOOLEAN,
source_database IN VARCHAR2,
source_root_name IN VARCHAR2);
TBD
Overload 2
dbms_xstream_utl_ivk.add_subset_outbound_rules(
server_name IN VARCHAR2,
table_name IN VARCHAR2,
condition IN VARCHAR2,
column_list IN VARCHAR2,
keep IN BOOLEAN,
source_database IN VARCHAR2,
source_root_name IN VARCHAR2);
dbms_xstream_utl_ivk.alter_outbound(
server_name IN VARCHAR2,
table_names IN dbms_utility.uncl_array,
schema_names IN dbms_utility.uncl_array,
add IN BOOLEAN,
capture_user IN VARCHAR2,
connect_user IN VARCHAR2,
comment IN VARCHAR2,
inclusion_rule IN BOOLEAN,
start_scn IN NUMBER,
start_time IN TIMESTAMP,
include_dml IN BOOLEAN,
include_ddl IN BOOLEAN,
source_database IN VARCHAR2);
TBD
Overload 2
dbms_xstream_utl_ivk.alter_outbound(
server_name IN VARCHAR2,
table_names IN VARCHAR2,
schema_names IN VARCHAR2,
add IN BOOLEAN,
capture_user IN VARCHAR2,
connect_user IN VARCHAR2,
comment IN VARCHAR2,
inclusion_rule IN BOOLEAN,
start_scn IN NUMBER,
start_time IN TIMESTAMP,
include_dml IN BOOLEAN,
include_ddl IN BOOLEAN,
source_database IN VARCHAR2);
dbms_xstream_utl_ivk.create_inbound(
server_name IN VARCHAR2,
queue_name IN VARCHAR2,
apply_user IN VARCHAR2,
comment IN VARCHAR2,
committed_data_only IN BOOLEAN,
scn_based_position IN BOOLEAN);
dbms_xstream_utl_ivk.create_outbound(
server_name IN VARCHAR2,
source_database IN VARCHAR2,
table_names IN dbms_utility.uncl_array,
schema_names IN dbms_utility.uncl_array,
capture_user IN VARCHAR2,
connect_user IN VARCHAR2,
comment IN VARCHAR2,
committed_data_only IN BOOLEAN,
capture_name IN VARCHAR2
include_dml IN BOOLEAN,
include_ddl IN BOOLEAN,
enable_procedure IN BOOLEAN,
source_root_name IN VARCHAR2
lcrid_version IN NUMBER);
TBD
Overload 2
dbms_xstream_utl_ivk.create_outbound(
server_name IN VARCHAR2,
source_database IN VARCHAR2,
table_names IN VARCHAR2,
schema_names IN VARCHAR2,
capture_user IN VARCHAR2,
connect_user IN VARCHAR2,
comment IN VARCHAR2,
committed_data_only IN BOOLEAN,
capture_name IN VARCHAR2,
include_dml IN BOOLEAN,
include_ddl IN BOOLEAN,
enable_procedure IN BOOLEAN,
source_root_name IN VARCHAR2,
lcrid_version IN NUMBER);