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

To test the tutorial later on, user SCOTT must select from the OE.CUSTOMERS table. First, you should ensure that he SCOTT account is active.

To enable user SCOTT: 

1. In Database Control, connect as the Oracle Database Vault Account Manager account with the Normal privilege.

   After you install Oracle Database Vault, you no longer can use the administrative accounts (such as SYS and SYSTEM) to create or enable user accounts. This is because right out of the box, Oracle Database Vault provides separation-of-duty principles to administrative accounts. From now on, to manage user accounts, you must use the Oracle Database Vault Account Manager account.

   However, administrative users still have the privileges they do need. For example, user SYS, who owns system privileges and many PL/SQL packages, can still grant privileges on these to other users. However, user SYS can no longer create, modify, or drop user accounts.

2. Click Server to display the Server subpage.

3. Under Security, select Users.

   The Users page appears.

4. Select the SCOTT user, and in the View User page, click Edit.

   The Edit User page appears.

5. Enter the following settings:

   • Enter Password and Confirm Password: If the SCOTT account password status is expired, then enter a new password. Enter any password that is secure, according to the password guidelines described in "Requirements for Creating Passwords".

   • Status: Click Unlocked.

6. Click Apply.

7. Click Logout.

To grant user SCOTT the SELECT privilege on the OE.CUSTOMERS table: 

1. Log in to SQL*Plus as user OE.

   sqlplus oe
   Enter password: password
   Connected. 
   

2. Grant user SCOTT the SELECT privilege on the OE.CUSTOMERS table.

   SQL> GRANT SELECT ON CUSTOMERS TO SCOTT;