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
Supporting utilities for replication
AUTHID
CURRENT_USER
Dependencies
ALL_CAPTURE
DBMS_LOGREP_UTIL_INVOK
DBMS_STREAMS_RPC
ALL_XSTREAM_OUTBOUND
DBMS_STANDARD
DBMS_STREAMS_SM
DBMS_APPLY_ADM
DBMS_STREAMS_ADM
DBMS_SYSTEM
DBMS_ASSERT
DBMS_STREAMS_ADM_UTL
DBMS_UTILITY
DBMS_CAPTURE_ADM
DBMS_STREAMS_ADM_UTL_INVOK
DBMS_XSTREAM_ADM
DBMS_CAPTURE_ADM_INTERNAL
DBMS_STREAMS_AUTO_INT
DBMS_XSTREAM_ADM_UTL
DBMS_LOGREP_UTIL
DBMS_STREAMS_DECL
DBMS_XSTREAM_GG_ADM
Documented
No
First Available
12.1
Security Model
Owned by SYS with EXECUTE granted to the EXECUTE_CATALOG_ROLE role
dbms_capture_adm_ivk.abort_schema_inst_ivk(
schema_name IN VARCHAR2,
container IN VARCHAR2);
-- appears to be runnable from pdb$root but have not tested this as there is no validation in this proc. exec dbms_capture_adm_ivk.abort_schema_inst_ivk('SCOTT', 'PDBDEV');
dbms_capture_adm_ivk.abort_table_inst_ivk(
table_name IN VARCHAR2,
container IN VARCHAR2);
-- appears to be runnable from pdb$root but have not tested this as there is no validation in this proc. exec dbms_capture_adm_ivk.abort_table_inst_ivk('SERVERS', 'PDBDEV');
dbms_capture_adm_ivk.create_capture_ivk(
queue_name IN VARCHAR2,
capture_name IN VARCHAR2,
rule_set_name IN VARCHAR2,
start_scn IN NUMBER,
source_database IN VARCHAR2,
user_database_link IN BOOLEAN,
first_scn IN NUMBER,
logfile_assignment IN VARCHAR2,
negative_rule_set_name IN VARCHAR2,
capture_user IN VARCHAR2,
checkpoint_retention_time IN NUMBER,
start_time IN TIMESTAMP,
enable_procedure IN BOOLEAN,
source_root_name IN VARCHAR2,
capture_class IN VARCHAR2,
clone_capture_name IN VARCHAR2);
dbms_capture_adm_ivk.supp_log_level_check(
supplemental_logging IN VARCHAR2,
check_for_keyalways IN BOOLEAN)
RETURN BINARY_INTEGER;
-- having no idea what the proper string for the first parameter is ... I threw something at it which it appears does not work but does prove out the validity of the syntax.
SELECT supplemental_log_data_min, supplemental_log_data_pk
FROM v$database;
SUPPLEME SUP
-------- ---
NO NO
SELECT dbms_capture_adm_ivk.supp_log_level_check('SUPPLEMENTAL_LOG_DATA_PK')
FROM dual;
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
SELECT supplemental_log_data_min, supplemental_log_data_pk
FROM v$database;
SUPPLEME SUP
-------- ---
YES NO
SELECT dbms_capture_adm_ivk.supp_log_level_check('SUPPLEMENTAL_LOG_DATA_PK')
FROM dual;