VPD (Virtual Private Database) and OBIEE

user2053645

I'm trying to fully implement VPD in OBIEE.  I have all set up in the connection area.  What I'm missing is exactly how to

set up the session initialization block and session variable.

Based upon the user who logs into obiee, I want to pass that userid back to our database that contains the data for the report

and restrict the row-level output in the report based upon who logged in.  I've seen snippets of how this is done on the web,

but exact screenshots for how to do in the initialization block would be very helpful.  I don't think I need a connection pool

in the initialization block.  I want to capture the obiee session variable for the person who logged in.  I need that exact syntax

so that I don't get an error when running the initialization block.  Once I have that variable captured, and passed to a session

variable, how does that relate to the connection pool I'm using to get the data?  Thank you.

John_K

To implement this at the OBIEE level you generally use security filters (which link to EM roles) rather than database level VPD. Any particular reason for wanting to use VPD?

user2053645

Hi - We resolved this as part of another ticket.  We are using VPD as we want all security controlled in the database.  VPD is working now.  I had to uncheck sharing the connection pool

in the connection object for it to fully work as desired.

User_PKUN0

@user2053645 Can you please let me know how you have implemented the VPD. I'm also trying to get the VPD implemented in the Database. If you can provide me steps to implement the VPD that will be very helpful.

SteveF-Oracle

@User_PKUN0 -- This thread is 6 years old from 2017. It should probably be closed/locked by a moderator.

Best practice when a thread is so old , it is best to start a new thread and ask your question.In the new topic, you can tag the user from this th

To enhance your experience and foster meaningful interactions, we encourage you to personalize your profile by setting up a display name and uploading a profile picture. Your display name will be how others recognize and engage with you in discussions, while a profile picture adds a personal touch to your forum presence.

Take a moment to update your profile with a display name and an image representing you. Let's create a vibrant and engaging community together!

In your case, you can start with the documentation here:

• Setting Up Row-Level Security in the Database

If you have follow-up, then ask in a new topic with the details of the steps you have taken.

I hope that helps.

Moderators, please close this topic.