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
Undocumented
AUTHID
CURRENT_USER
Dependencies
DBA_APPLY
DBMS_CAPTURE_ADM_IVK
DBMS_SYS_ERROR
DBA_CAPTURE
DBMS_LOB
DBMS_UTILITY
DBA_CAPTURE_PARAMETERS
DBMS_LOCK
GLOBAL_NAME
DBA_PROPAGATION
DBMS_LOGREP_UTIL
GV$BUFFERED_SUBSCRIBERS
DBA_QUEUES
DBMS_RECOVERABLE_SCRIPT
GV$PROPAGATION_RECEIVER
DBA_QUEUE_TABLES
DBMS_SCHEDULER
STREAMS$_APPLY_PROCESS
DBA_RECOVERABLE_SCRIPT
DBMS_SERVER_ALERT
STREAMS$_CAPTURE_PROCESS
DBA_RECOVERABLE_SCRIPT_PARAMS
DBMS_SERVER_ALERT_PRVT
STREAMS$_CAPTURE_SERVER
DBA_SCHEDULER_JOBS
DBMS_STANDARD
STREAMS$_PROCESS_PARAMS
DBA_SCHEDULER_SCHEDULES
DBMS_STREAMS_ADM
STREAMS$_SPLIT_MERGE
DBA_USERS
DBMS_STREAMS_ADM_IVK
UTL_FILE
DBMS_APPLY_ADM
DBMS_STREAMS_ADM_UTL
_DBA_GGXSTREAM_OUTBOUND
DBMS_ASSERT
DBMS_STREAMS_AUTO_INT
_GV$SXGG_CAPTURE
DBMS_CAPTURE_ADM_INTERNAL
DBMS_SYSTEM
Documented
No
First Available
Not known
Security Model
Owned by SYS with EXECUTE granted to the EXECUTE_CATALOG_ROLE role.
dbms_streams_sm.merge_streams(
canon_capture_name IN OUT VARCHAR2,
canon_cloned_capture_name IN OUT VARCHAR2,
canon_streams_name IN OUT VARCHAR2,
canon_cloned_streams_name IN VARCHAR2,
streams_type IN NUMBER,
canon_queue_owner IN OUT VARCHAR2,
canon_queue_name IN OUT VARCHAR2,
canon_cloned_queue_owner IN OUT VARCHAR2,
canon_cloned_queue_name IN OUT VARCHAR2,
autosplit IN BOOLEAN,
perform_actions IN BOOLEAN,
canon_script_dirobj IN VARCHAR2,
script_name IN VARCHAR2);
dbms_streams_sm.merge_streams_job(
canon_capture_name IN VARCHAR2,
canon_cloned_capture_name IN VARCHAR2,
canon_streams_name IN VARCHAR2,
canon_cloned_streams_name IN VARCHAR2,
streams_type N NUMBER,
canon_queue_name IN VARCHAR2,
canon_queue_owner IN VARCHAR2,
merge_threshold IN NUMBER,
canon_merge_schedule_owner IN VARCHAR2,
canon_merge_schedule_name IN VARCHAR2,
canon_merge_job_owner IN VARCHAR2,
canon_merge_job_name IN VARCHAR2,
autosplit IN BOOLEAN);
dbms_streams_sm.set_job_next_run(
canon_job_name IN VARCHAR2,
s_date IN TIMESTAMP,
interval IN VARCHAR2,
e_date IN TIMESTAMP,
canon_job_owner IN VARCHAR2);
dbms_streams_sm.split_streams(
canon_propagation_name IN VARCHAR2,
canon_cloned_propagation_name IN OUT VARCHAR2,
canon_cloned_queue_owner IN OUT VARCHAR2,
canon_cloned_queue_name IN OUT VARCHAR2,
canon_cloned_capture_name IN OUT VARCHAR2,
perform_actions IN BOOLEAN,
canon_script_dirobj IN VARCHAR2,
script_name IN VARCHAR2,
auto_merge_threshold IN NUMBER,
canon_merge_schedule_owner IN OUT VARCHAR2,
1canon_merge_schedule_name IN OUT VARCHAR2,
1canon_merge_job_owner IN OUT VARCHAR2,
1canon_merge_job_name IN OUT VARCHAR2);
dbms_streams_sm.split_streams_internal(
canon_streams_name IN VARCHAR2,
canon_cloned_streams_name IN OUT VARCHAR2,
streams_type IN NUMBER,
canon_cloned_queue_owner IN OUT VARCHAR2,
canon_cloned_queue_name IN OUT VARCHAR2,
canon_capture_name IN OUT VARCHAR2,
canon_cloned_capture_name IN OUT VARCHAR2,
perform_actions IN BOOLEAN,
canon_script_dirobj IN VARCHAR2,
script_name IN VARCHAR2,
auto_merge_threshold IN NUMBER,
canon_merge_schedule_owner IN OUT VARCHAR2,
canon_merge_schedule_name IN OUT VARCHAR2,
canon_merge_job_owner IN OUT VARCHAR2,
canon_merge_job_name IN OUT VARCHAR2,
autosplit IN BOOLEAN);