Oracle | DBMS_REDACT

Oracle DBMS_REDACT_INT Version 23c

General Information

Library Note

Morgan's Library Page Header

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 Internal support for DBMS_REDACT data redaction

AUTHID DEFINER

Dependencies

DBMS_REDACT

DBMS_REDACT_LIB

Documented No

First Available Not known

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/prvtredacta.plb

Subprograms

ADD_POLICY	DISABLE_POLICY	FPM_MASK
ALTER_POLICY	DROP_POLICY	FPM_UNMASK
APPLY_POLICY_EXPR_TO_COL	DROP_POLICY_EXPRESSION	UPDATE,_FULL_REDACTION_VALUES
CREATE_POLICY_EXPRESSION	ENABLE_POLICY	UPDATE,_POLICY_EXPRESSION

ADD_POLICY

Undocumented dbms_redact_int.add_policy( object_schema IN VARCHAR2, object_name IN VARCHAR2, policy_name IN VARCHAR2, policy_description IN VARCHAR2, column_name IN VARCHAR2, column_description IN VARCHAR2, function_type IN BINARY_INTEGER, function_parameters IN VARCHAR2, expression IN VARCHAR2, enable IN BOOLEAN, regexp_pattern IN VARCHAR2, regexp_replace_string IN VARCHAR2, regexp_position IN BINARY_INTEGER, regexp_occurrence IN BINARY_INTEGER, regexp_match_parameter IN VARCHAR2, current_user IN VARCHAR2, current_user_id IN BINARY_INTEGER);

TBD

ALTER_POLICY

Undocumented dbms_redact_int.alter_policy( object_schema IN VARCHAR2, object_name IN VARCHAR2, policy_name IN VARCHAR2, action IN BINARY_INTEGER, column_name IN VARCHAR2, function_type IN BINARY_INTEGER, function_parameters IN VARCHAR2, expression IN VARCHAR2, regexp_pattern IN VARCHAR2, regexp_replace_string IN VARCHAR2, regexp_position IN BINARY_INTEGER, regexp_occurrence IN BINARY_INTEGER, regexp_match_parameter IN VARCHAR2, policy_description IN VARCHAR2, column_description IN VARCHAR2, current_user IN VARCHAR2, current_user_id IN BINARY_INTEGER);

TBD

APPLY_POLICY_EXPR_TO_COL

Undocumented dbms_redact_int.apply_policy_expr_to_col( object_schema IN VARCHAR2, object_name IN VARCHAR2, column_name IN VARCHAR2, policy_expression_name IN VARCHAR2, current_user IN VARCHAR2, current_user_id IN BINARY_INTEGER);

TBD

CREATE_POLICY_EXPRESSION

Undocumented dbms_redact_int.create_policy_expression( policy_expression_name IN VARCHAR2, expression IN VARCHAR2, policy_expression_description IN VARCHAR2, current_user IN VARCHAR2, current_user_id IN BINARY_INTEGER);

TBD

DISABLE_POLICY

Undocumented dbms_redact_int.disable_policy( object_schema IN VARCHAR2, object_name IN VARCHAR2, policy_name IN VARCHAR2, current_user IN VARCHAR2, current_user_id IN BINARY_INTEGER);

TBD

DROP_POLICY

Undocumented dbms_redact_int.drop_policy( object_schema IN VARCHAR2, object_name IN VARCHAR2, policy_name IN VARCHAR2, current_user IN VARCHAR2, current_user_id IN BINARY_INTEGER);

TBD

DROP_POLICY_EXPRESSION

Undocumented dbms_redact_int.drop_policy_expression( policy_expression_name IN VARCHAR2, current_user IN VARCHAR2, current_user_id IN BINARY_INTEGER);

TBD

ENABLE_POLICY

Undocumented dbms_redact_int.enable_policy( object_schema IN VARCHAR2, object_name IN VARCHAR2, policy_name IN VARCHAR2, current_user IN VARCHAR2, current_user_id IN BINARY_INTEGER);

TBD

FPM_MASK

Undocumented dbms_redact_int.fpm_mask( input_format IN VARCHAR2, output_format IN VARCHAR2, input_value IN VARCHAR2, masking_key IN VARCHAR2,);

TBD

FPM_UNMASK

Undocumented dbms_redact_int.fpm_unmask( input_format IN VARCHAR2, output_format IN VARCHAR2, input_value IN VARCHAR2, masking_key IN VARCHAR2,);

TBD

UPDATE,_FULL_REDACTION_VALUES

Undocumented dbms_redact_int.upDATE,_full_redaction_values( number_val IN NUMBER binfloat_val IN BINARY_FLOAT, bindouble_val IN BINARY_DOUBLE, char_val IN CHAR, varchar_val IN VARCHAR2, nchar_val IN NCHAR, nvarchar_val IN NVARCHAR2, date_val IN DATE, ts_val IN TIMESTAMP tswtz_val IN TIMESTAMP WITH TIME ZONE, blob_val IN BLOB, clob_val IN CLOB, nclob_val IN NCLOB, current_user IN VARCHAR2, current_user_id IN BINARY_INTEGER);

TBD

UPDATE,_POLICY_EXPRESSION

Undocumented dbms_redact_int.upDATE,_policy_expression( policy_expression_name IN VARCHAR2, expression IN VARCHAR2, policy_expression_description IN VARCHAR2, current_user IN VARCHAR2, current_user_id IN BINARY_INTEGER);

TBD