Step 6: 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 revoke the SELECT privilege on OE.CUSTOMERS from user SCOTT: 

1. In SQL*Plus, connect as user OE.

   CONNECT OE
   Enter password: password
   Connected. 
   

2. Revoke the SELECT privilege from user SCOTT.

   REVOKE SELECT ON CUSTOMERS FROM SCOTT;
   

To drop the OE Protections realm: 

1. If you have logged out of Oracle Database Vault Administrator, log back in as the Database Vault Owner account that you created when you installed Oracle Database Vault (for example, DBVOWNER).

   See Step 1 in "Step 4: Create a Realm to Protect the OE.CUSTOMERS Table" for how to start Database Vault Administrator.

   The Administration page appears.

2. Under Database Vault Feature Administration, click Realms.

   The Realms page appears.

3. Select OE Protections from the list of realms, and then click Remove. Then click Yes in the Confirmation page.

4. Log out of Oracle Database Vault Administrator.

To disable Oracle Database Vault: 

• See Oracle Database Vault Administrator's Guide for information about disabling Oracle Database Vault.