Oracle VPD
Date: Thu, 24 Jun 2021 17:26:45 +0000 (UTC)
Message-ID: <1755352648.85157.1624555605227_at_mail.yahoo.com>
Hi Everyone
I am working on masking/restricting data access to certain users on multiple tables based on some column data filtering. Schema1.Table1 has column mfg_data where I need to block access based on values to certain reporting users.
Question is that there are multiple tables and filtering is based on same column in all tables and so I need to explore if 1. I can use view on all of these table with filtering the required data and assign only access to these views to Reporting users 2. Or do the VPD setup to control it.
Need to get Pros and cons of both option based on Performance as it will be on multiple tables. Also any reported bug or issue with the usage like performance or using VPD and DBMS_redef or MV refresh or so
Please share your experience
TxSanjay
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jun 24 2021 - 19:26:45 CEST