Enabling Virtual Private Database in OBIEE
Once the VPD is set at the database level, it needs to be enabled within OBIEE. The configuration enables OBIEE to set the correct application contexts within the database.
Getting ready
Open the Oracle BI Administration Tool window and connect to the repository. Open SQL Developer and log in as the schema owner.
How to do it...
In the previous recipes for VPD, you created an application context package and some function, to restrict row and column data. In this recipe, we will build upon that knowledge to integrate the same concepts into OBIEE to be able to provide row- and column-level security.
- Update your context package to set all the necessary context values for OBIEE in SQL Developer. This will replace ...
Get Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
