Step 7: Optionally, Remove the Components for This Tutorial

After completing this tutorial, you can remove the data structures that you used if you no longer need them.

To remove the data structures created by sec_admin: 

1. In Database Control, log in as user sec_admin.

2. Click Server to display the Server subpage.

3. Under Security, select Virtual Private Database.

   The Virtual Private Database Policies page appears.

4. Under Search, enter the following information, and then click Go:

   • Schema Name: OE

   • Object Name: ORDERS

   • Policy Name: %

   The policy you created, ACCESSCONTROL_ORDERS, is listed.

5. Select ACCESSCONTROL_ORDERS, and then click Delete.

6. In the Confirmation page, click Yes.

To remove the user accounts and roles: 

1. In Database Control, click Logout, and then Login.

2. Log in as the administrative user (for example, SYSTEM) who created the user accounts and roles used in this tutorial.

3. Click Server to display the Server subpage.

4. Under Security, select Users.

   The Users page appears.

5. Select each of the following users, and then click Delete to remove them:

   • LDORAN

   • LPOPP

   Do not remove sec_admin because you will need this account for later tutorials in this guide.

6. Exit Database Control.