Re: VPD
Date: Thu, 14 Jun 2018 15:30:34 +0200
Message-ID: <163fe7d9890.278e.f39e3e69b57dc29d82f1c76ed37cd589_at_gmail.com>
Hi
Vpd will solve your problem easily.
Cheers
Jki
Le 14 juin 2018 15:26:26 "Sanjay Mishra" <dmarc-noreply_at_freelists.org>
(Redacted sender "smishra_97" for DMARC) a écrit :
> Hi Everyone
>
> Need some view on best approach to do data masking. I had around 8-10
> tables with 2 columnn that has secured financial data. Column name are same
> in all tables where data need to masked.
>
> The requirement is that there are 500 users in the database and data need
> to be restricted using these 2 columns for these 10 tables
> 1. One set of the user will have access to all Data
> 2. Another set can use column 1 value condition
> 3. Another set of the user who can see the data based on Column 2 value
> condition
>
> Oracle 12.1 and has Enterprise license for all Oracle options. ANy
> approach that can help in creating the plan will be helpful
>
> TIA
> Sanjay
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jun 14 2018 - 15:30:34 CEST