Setting the default displayed values for full redaction - Amazon Relational Database Service
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

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.