=============================================================================================================
Masking Enable for table column in oracle.
=============================================================================================================
What is
Redaction and types of redactions?
·
Full Redaction: - you Redact all of the contents of
the Column Data. the redacted values that is returned to the querying user
depends on the Data type of the column.
for Example: if there is column of the Number data type Redacted with a
Zero (0) and character Data type are Redacted with Blank Space
·
Partial
Redaction: - We Redact a portion of the Column Data. For example, you can
redact most of a Social Security number with asterisks (*), except for the last
4 digits.
·
Regular
expressions: -You can use regular expressions in both full and partial
redactions. This enables you to redact data based on a search pattern for the
data.
For example, you can use regular expressions to redact specific phone
numbers or email addresses in your data.
·
Random
redaction: The redacted data
presented to the querying user appears as randomly generated values each time
it is displayed, depending on the data type of the column.
·
No redaction. This option enables you to test
the internal operation of your redaction policies, with no effect on the
results of queries against tables with policies defined on them You can use
this option to test the redaction policy definitions before applying them to a
production environment.
Step – 1 Firstly we have login through the Sys user in database and we need to
provide the grant which user for want
to apply masking. this demonstration below steps for full redaction
SQL >
GRANT EXECUTE ON sys. dbms_redact to farukh_afprod;
Step – 2 We need to be connected which user want to mask the
table column.
Step- 3 Once it successfully applied, we need to
validate of this masking and send it be the app owner for the testing.
Note: - if
you want to visual same masked object column for the other schemas we need to
execute this below command for the same
SQL> GRANT
EXEMPT REDACTION POLICY TO India_afprod ;
Note : Oracle introduced this feature with oracle 11g R2 onwards .
If you are going to enable this features, There’s oracle commercial will be applicable .
Please check with license part as well before going to availe this feature .
Thank you to All ....
Thank you for giving your valuable time to read the above information.