Creating a driving context

In the previous recipe, you saw that having multiple VPD policies (most probably created because multiple application use that same table) is harder to manage, and it can lead to unexpected/unwanted results.

For example, you have two applications and want to create two policy groups. If the first application accesses the table, the test_pol1 and test_col policies should be enforced, and if second application accesses the table, the test_pol2 policies should be applied. There will be no default policies.

In this recipe, you'll create an application context and set it.

Getting ready

To complete this recipe, you'll need an existing user who can create an application context (for example, the user maja).

How to do it...

1. Connect to the database as a user who has appropriate privileges (for example, the user maja):

   $ sqlplus maja
   

2. Create a driving context (for example, driver_ctx):

   SQL> CREATE CONTEXT driver_ctx using driver_ctx_pkg;
   

3. Set the driving context:

   SQL> CREATE...