![]() You can see the default values by querying the REDACTION_VALUES_FOR_TYPE_FULL view, shown by the following example that uses the redaction_columns.sql script.Ĭonn as BINARY_FLOAT_VALUE BINARY_DOUBLE_VALUE CHAR_VALUE VARCHAR_VA NCHAR_VALU NVARCHAR_V DATE_VALUE TIMESTAMP_VALUE TIMESTAMP_WITH_TIME_ZONE_VALUE BLOB_VALUE CLOB_VALUE NCLOB_VALUĠ 0 0 0 00:00:00 0 01:00:00.000000 01-JAN-01 01.00 +00:00 5B72656461637465645D The value displayed by full redaction is based on the data type defaults for the DBMS_REDACT.FULL function type. We can see the CARD_NO column is now redacted to the number "0". A full redaction policy is placed on the CARD_NO column with an expression of "1=1". The following example is about as simple as it gets. Alternatively, situational expressions can be defined using the SYS_CONTEXT function. For example, an expression of "1=1" means the redaction will always take place. When should it happen? : The EXPRESSION parameter determines when the redaction should take place.Depending on the type of redaction selected, you may be required to specify the FUNCTION_PARAMETERS or various REGEXP_* parameters. What should happen? : The FUNCTION_TYPE parameter determines the type of redaction that should take place.Give it a name : The POLICY_NAME parameter assigns a name to the policy.Identify the object : The OBJECT_SCHEMA, OBJECT_NAME and COLUMN_NAME parameters identify the column to be redacted.A policy is made up of several distinct sections. The example code in this article requires the following test table.Ĭonstraint payment_details_pk primary key (id) Grant execute on sys.dbms_redact to testuser1 ![]() We need to make sure the first test user has access to the DBMS_REDACT package. ![]() ![]() Grant create session, create table to testuser1 Ĭreate user testuser2 identified by testuser2 quota unlimited on users ![]() Data Redaction (DBMS_REDACT) Enhancements in Oracle Database 12c Release 2 (12.2)Ĭreate user testuser1 identified by testuser1 quota unlimited on users.Redaction is part of Oracle Advanced Security, which is a separately licensed Enterprise Edition option. ![]()
0 Comments
Leave a Reply. |