Step 7: Apply the ACCESS_LOCATIONS Policy to the HR.LOCATIONS Table

Next, you are ready to apply the policy to the HR.LOCATIONS table.

To apply the ACCESS_LOCATIONS policy to the HR.LOCATIONS table: 

1. Return to the Label Security policies page by selecting the Label Security Policies link.

2. Select the selection button for the ACCESS_LOCATIONS policy.

3. In the Actions list, select Apply, and then click Go.

   The Apply page appears.

4. Click Create.

   The Add Table page appears.

5. In the Table field, enter HR.LOCATIONS.

6. Ensure that the Hide Policy Column box is not selected.

7. Ensure that the Enabled box is selected.

8. Under Policy Enforcement Options, select Use Default Policy Enforcement.

   The default policy enforcement options for ACCESS_LOCATIONS are:

   • For all queries (READ_CONTROL)

   • Use session's default label for label column update (LABEL_DEFAULT)

9. Click OK.

   The ACCESS_LOCATIONS policy is applied to the HR.LOCATIONS table.