Skip to Main Content

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, subramanyam.

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

Last updated: October 27, 2020 - 1:36 am UTC

Version: 12c

Viewed 1000+ 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 Connor 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"


Rating

  (1 rating)

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

Comments

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

Steve, October 22, 2020 - 2:42 pm UTC

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
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

More to Explore

Security

All of the vital components for a secure database are covered in the Security guide.