Re: Oracle VPD
Date: Fri, 25 Jun 2021 18:33:21 +0000
Message-ID: <BN6PR01MB2547C85155A11FA8992138D4CE069_at_BN6PR01MB2547.prod.exchangelabs.com>
Sanjay, it seems to me that both options are available to you. I think how the users are going to access the data will determine which option you choose. If all access is via an ad hoc reporting tool then the view approach works well, but if the access is to be from one application screen for all users, then you probably want to use VPD.
Mark Powell
Database Administration
(313) 592-5148
From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Sanjay Mishra <dmarc-noreply_at_freelists.org> Sent: Thursday, June 24, 2021 1:26 PM
To: Oracle List <oracle-l_at_freelists.org> Subject: Oracle VPD
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
Tx
Sanjay
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jun 25 2021 - 20:33:21 CEST