Oracle | DBMS_REDACT

Oracle DBMS_REDACT_INT Version 21c

General Information

Library Note

Morgan's Library Page Header

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 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