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.
To complete this recipe, you'll need an existing user who can create an application context (for example, the user maja
).