Adding policy to a group
In this recipe, create VPD policies as part of a policy group.
Getting ready
To complete this recipe, you'll need an existing user who has appropriate privileges (for example, maja
). If you completed previous recipes, drop all VPD policies using the DBMS_RLS.DROP_POLICY
procedure.
How to do it...
- Connect to the database as a user who has appropriate privileges (for example, the user
maja
):$ sqlplus maja
- Add
TEST_POL1
to policy grouppol_grp_A
. - Add
TEST_COL
to policy grouppol_grp_A
. - Add
TEST_POL2
to policy ...
Get Oracle Database 12c Security Cookbook 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.