Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, subramanyam.

Asked: March 15, 2017 - 7:32 pm UTC

Answered by: Connor McDonald - Last updated: October 27, 2020 - 1:36 am UTC

Category: Database - Version: 12c

Viewed 100+ times

You Asked

Hello

I have a question on oracle redaction.
Can oracle redaction be turned on based on a value in a column?

please let me know


Thanks

subramanyam

and we said...

No.

From the docs:

https://docs.oracle.com/database/121/ASOAG/redaction_config.htm#ASOAG10583


"This expression must be based on one of the following functions:
- SYS_CONTEXT
- The following Oracle Application Express functions: V, NV
- The OLS_LABEL_DOMINATES function"


and you rated our response

  (1 rating)

Is this answer out of date? If it is, please let us know via a Review

Reviews

Will this change near future (eg Oracle 21c) ?

October 22, 2020 - 2:42 pm UTC

Reviewer: Steve from United Kingdom

I have heard with GDPR there are customer rules that kick in after 7 years. 
So,  it would be nice to mask a telephone depending on different column.For example whenever last-update-date being lessthan '01-Jan-2013' ?!  perhaps using the expression parameter of DBMS_REDACT.add_policy()
OR

Do you think DBMS_REDACT could be applied to just one-partition of table?



Connor McDonald

Followup  

October 27, 2020 - 1:36 am UTC

You can log database ideas here

https://community.oracle.com/tech/welcome/categories/15571

I too think its a good idea