title: Accessing a table without specifying the schema name
body: <p>I have a schema called <code>GBO_ARC_SCHEMA</code>, in which I have one table called <code>TEST_EMP</code>,
  and I have two users say <code>USER_A</code> and <code>USER_B</code>.</p>
  
  <p>First I connected to <code>USER_A</code> and fired below query</p>
  
  <pre><code>select count(*)from TEST_EMP;
  
  count
  -----
  20
  </code></pre>
  
  <p>After that I connected as <code>USER_b</code> and fired below query but it is giving an error, saying that table or view does not exit</p>
  
  <pre><code>select count(*)from TEST_EMP;
  </code></pre>
  
  <p>But if I use <code>scma.object name</code> it is allowing me to query like below</p>
  
  <pre><code>select count(*)from GBO_ARC_SCHEMA.TEST_EMP;
  </code></pre>
  
  <p>but as per my requirement I don't want to specify schema name.</p>
  
  <p>can somebody help me out?</p>