Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 42 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 277 Oracle Analytics and AI News
- 50 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 19 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
VPD Restrict Data Access
Summary
VPD Restrict Data Access
Content
Hello,
I'm working on OTM V 6.4.2 and I want to make it required that, when a service provider declines a tender, he needs to fill a reason code.
Thus i'm creating a VPD for service providers and it has to have this structure (can't change it):
"select * from tablename where ...."
but after the where I don't know what to put as I am a newbie in SQL. I want to say "if acceptance_code = 'D' then decline_reason_code can't be null "
Thanks
Answers
-
looks this is not related to bip (but we can implemnent VPD in BIP to restrict row or column level security , VPD (virtual private database) if you are asking about how set up VPD then =please ask question in oracle database community.
0 -
Hi Venkythota54
Are you aware of any documentation regarding VPD for BI implementation? I came across this in the Oracle Subscription learning material but there was little guidance (or even a lab) to explain how you would do this in a SAAS environment.
Thanks.
0 -
Hi @Ms_Oracle please refer below link this would give you more idea on how VPD works in BI Publisher with an example from Human resources module.
Please let me know if this helps.
Regards,
Swapnil
0
