VPD Restrict Data Access

Antoine KAIBER

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

Venkat Thota - BIP

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.

Ms_Oracle

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.

Swapnil Kashid

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.

https://community.oracle.com/customerconnect/discussion/43859/share-information-on-how-the-security-works-with-bi-publisher-example-with-per-person-secured-list-v

Please let me know if this helps.

Regards,

Swapnil