View a markdown version of this page

⭐ Must Read: AmazonRDS/latest/UserGuide/Appendix.Oracle.CommonDBATasks.FullRedaction.html - ประเด็นร้อน

Setting the default displayed values for full redaction

To change the default displayed values for full redaction on your Amazon RDS Oracle instance, use the Amazon RDS procedure rdsadmin.rdsadmin_util.dbms_redact_upd_full_rdct_val. Note that you create a redaction policy with the DBMS_REDACT PL/SQL package, as explained in the Oracle Database documentation. The dbms_redact_upd_full_rdct_val procedure specifies the characters to display for different data types affected by an existing policy.

The dbms_redact_upd_full_rdct_val procedure has the following parameters.

Parameter name Data type Default Required Description

p_number_val

number

Null

No

Modifies the default value for columns of the NUMBER data type.

p_binfloat_val

binary_float

Null

No

Modifies the default value for columns of the BINARY_FLOAT data type.

p_bindouble_val

binary_double

Null

No

Modifies the default value for columns of the BINARY_DOUBLE data type.

p_char_val

char

Null

No

Modifies the default value for columns of the CHAR data type.

p_varchar_val

varchar2

Null

No

Modifies the default value for columns of the VARCHAR2 data type.

p_nchar_val

nchar

Null

No

Modifies the default value for columns of the NCHAR data type.

p_nvarchar_val

nvarchar2

Null

No

Modifies the default value for columns of the NVARCHAR2 data type.

p_date_val

date

Null

No

Modifies the default value for columns of the DATE data type.

p_ts_val

timestamp

Null

No

Modifies the default value for columns of the TIMESTAMP data type.

p_tswtz_val

timestamp with time zone

Null

No

Modifies the default value for columns of the TIMESTAMP WITH TIME ZONE data type.

p_blob_val

blob

Null

No

Modifies the default value for columns of the BLOB data type.

p_clob_val

clob

Null

No

Modifies the default value for columns of the CLOB data type.

p_nclob_val

nclob

Null

No

Modifies the default value for columns of the NCLOB data type.

The following example changes the default redacted value to * for the CHAR data type:

EXEC rdsadmin.rdsadmin_util.dbms_redact_upd_full_rdct_val(p_char_val => '*');

The following example changes the default redacted values for NUMBER, DATE, and CHAR data types:

BEGIN
rdsadmin.rdsadmin_util.dbms_redact_upd_full_rdct_val(
    p_number_val=>1,
    p_date_val=>to_date('1900-01-01','YYYY-MM-DD'),
    p_varchar_val=>'X');
END;
/

After you alter the default values for full redaction with the dbms_redact_upd_full_rdct_val procedure, reboot your DB instance for the change to take effect. For more information, see Rebooting a DB instance.