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.

Figure 27 - Drop policies

How to do it...

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

   $ sqlplus maja
   

2. Add TEST_POL1 to policy group pol_grp_A.

   

3. Add TEST_COL to policy group pol_grp_A.

   

4. Add TEST_POL2 to policy group pol_grp_B.

   

5. Create a logon trigger.

   

6. Connect to the database as the user joel using SQL*Plus and execute the SELECT statement, as shown in Figure 32.

   

   Figure 32

7. View data in the table hr.emp_vpd_test.

   

   Figure 33

8. Connect to the database as the user susan using SQL*Plus and view data in the table hr.emp_vpd_test:

   SQL> connect susan
   

   

9. Connect as the user emma using SQL Developer and view data in the table hr.emp_vpd_test.