Tutorial: Controlling Administrator Access to the OE Schema

The OE schema has several tables that contain confidential data, such as the credit limits allowed for customers and other information. Order Entry tables typically contain sensitive information, such as credit card or Social Security numbers. This type of information must be restricted only to individuals whose job requires access to this information, according to Payment Card Industry (PCI) Data Security Standards (DSS).

In this tutorial, you create a realm around the OE schema, which will protect it from administrator access. However, user SCOTT needs access to the OE.CUSTOMERS table, so you must ensure that he can continue to access this data.

In this tutorial:

• Step 1: Enable Oracle Database Vault

• Step 2: Grant the SELECT Privilege on the OE.CUSTOMERS Table to User SCOTT

• Step 3: Select from the OE.CUSTOMERS Table as Users SYS and SCOTT

• Step 4: Create a Realm to Protect the OE.CUSTOMERS Table

• Step 5: Test the OE Protections Realm

• Step 6: Optionally, Remove the Components for This Tutorial