ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling
complimentary technical Workshops on Database Security for the first 30
Oracle Database customers located anywhere in North America, EMEA, LATAM, or
APAC that send an email to
asra_us@oracle.com. Request a Workshop for
your organization today.
Purpose
Recovery Appliance (Recovery
Appliance) Backup and Recovery Support for data masking with workload captures and replays.
AUTHID
DEFINER
Dependencies
DBA_WORKLOAD_CAPTURES
DBMS_WORKLOAD_REPLAY
WRH$_SQL_PLAN
DBMS_RAT_MASK
DBMS_WRR_INTERNAL
WRI$_MASKING_SCRIPT_PROGRESS
DBMS_SQLTUNE_LIB
DUAL
WRR$_CAPTURES
DBMS_STANDARD
PRVT_SMGUTIL
WRR$_REPLAYS
DBMS_SYS_ERROR
V$DATABASE
XMLTYPE
DBMS_WORKLOAD_CAPTURE
WRH$_SQLSTAT
Documented
No
First Available
12.1
Security Model
Owned by SYS with no privileges granted.
Direct access to some objects in this package is prevented by means of an Accessible By clause forcing access through DBMS_RAT_MASK.
API for the extract phase of rat masking for capture files. It makes a call out to the kernel function which iterates over each statement in each capture file and extracts all sensitive bind values.
dbms_rat_mask_internal.i_dbr_extract_data(
capture_directory IN VARCHAR2,
script_id IN NUMBER);
API for the mask phase of rat masking for capture files. It makes a call out to the kernel function which iterates over each stmt in each cap file and replaces the values of all sensitive binds with masked values. It also removes binds in AWR.
dbms_rat_mask_internal.i_dbr_mask_data(
capture_directory IN VARCHAR2,
script_id IN NUMBER);
SELECT dbms_rat_mask_internal.i_get_rat_version
FROM dual;
*
ERROR at line 1:
ORA-06553: PLS-904: insufficient privilege to access object
DBMS_RAT_MASK_INTERNAL
dbms_rat_mask_internal.i_initialize_masking(
user_name IN VARCHAR2, -- user executing the masking script
package_name IN VARCHAR2, -- name of masking package
mask_definition IN XMLTYPE, -- xml of masking definition
control_xml IN XMLTYPE DEFAULT NULL); -- control xml from masking definition
API for the extract phase of rat masking for SQL tuning sets. It makes a call out to the kernel function which iterates over each statement in each STS in the db and extracts all sensitive bind values.
dbms_rat_mask_internal.i_spa_extract_data(script_id IN NUMBER);
API for the mask phase of rat masking for SQL tuning sets. It makes a call out to the kernel function which iterates over each stmt in each STS in the db and replaces the values of all sensitive binds with masked values.
It also removes peeked binds present in the other_xml column of the plan lines table.
dbms_rat_mask_internal.i_spa_mask_data(script_id IN NUMBER);