Home -> Mailing Lists -> Oracle-L -> Re: VPD

Re: VPD

From: Sanjay Mishra <"Sanjay>
Date: Thu, 14 Jun 2018 15:53:44 +0000 (UTC)
Message-ID: <1899816438.4983218.1528991624497_at_mail.yahoo.com> 








 YEs VPD look like is the solution and so looking for some high level approach from the experts who has worked with VPD.
TxSanjay


    On Thursday, June 14, 2018, 9:31:33 AM EDT, Jko <jacques.kostic_at_gmail.com> wrote:  
 


 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 tables1. One set of the user will have access to all Data2. Another set can use  column 1 value condition3. 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-l


Received on Thu Jun 14 2018 - 17:53:44 CEST












Original text of this message