title: Allowing a users to select from a table
body: <p>The emp table does exist for cis605 and I want to assign permissions to user. Any ideas to what I am doing wrong?   </p>
  
  <pre><code>SQL&gt; grant select on emp to user;
  
       Grant succeeded.
  
       SQL&gt; connect user
       Enter password:
       Connected.
       SQL&gt; select * from emp;
       select * from emp
                     *
       ERROR at line 1:
       ORA-00942: table or view does not exist
  </code></pre>
  
  <p>I have also tried doing it differently </p>
  
  <pre><code>     SQL&gt; connect cis605
       Enter password:
       Connected.
       SQL&gt; grant select on system.emp to chap7;
       grant select on system.emp to chap7
                               *
       ERROR at line 1:
       ORA-00942: table or view does not exist
  </code></pre>
  
  <p>Heres the statement I should have been using</p>
  
  <p>SQL> SELECT * from cis605.emp;</p>