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

At this stage, both users SYS and SCOTT can select from the OE.CUSTOMERS table, because SYS has administrative privileges and because SCOTT has an explicit SELECT privilege granted by user OE.

To select from OE.CUSTOMERS as users SYS and SCOTT: 

1. In SQL*Plus, connect as user SYS using the SYSDBA privilege

   sqlplus sys as sysdba
   Enter password: password
   

2. Select from the OE.CUSTOMERS table as follows:

   SELECT COUNT(*) FROM OE.CUSTOMERS;
   

   The following output should appear

   COUNT(*)
   --------
        319
   

3. Connect as user SCOTT, and then perform the same SELECT statement.

   CONNECT SCOTT
   Enter password: password
   Connected.
   
   SELECT COUNT(*) FROM OE.CUSTOMERS;
   

   The following output should appear:

   COUNT(*)
   --------
        319