title: Unable to grant any privileges to user in oracle 11gR2 except create session
body: <p>I am using oracle database 11g Release 2
  I am able to create user and give it create session privileges, but I am unable to give it select privilege.</p>
  
  <pre><code>create user user1 identified by pass;
  User created.
  grant create session to user1;
  Grant succeeded.
  grant select on emp to user1;
  Grant succeeded.
  </code></pre>
  
  <p>After this I connect as user1
  Now when I run this statement it say</p>
  
  <pre><code>select * from emp;
  </code></pre>
  
  <p>oracle reply=</p>
  
  <pre><code>ERROR at line 1:
  ORA-00942: table or view does not exist
  </code></pre>
  
  <p>Than I checked privileges to user1 using</p>
  
  <pre><code>select * from session_privs;
  PRIVILEGE
  ---------------------------------
  CREATE SESSION
  </code></pre>
  
  <p>Which means only create session privilege is available to user1. How can I give select privileges to user1? </p>