DBA readonly account
<p>I had a schema in one oracle DB as ui_prod. I asked my DBA team guys to create exactly same schema like ui_prod but as read only and name it ui_prod_readonly. Usually I will use Oracle SQL developer to connect a DB and query directly with table name like below.</p>

<pre><code>--Connect to ui_prod
select * from table
</code></pre>

<p>but why I requested to put owner name infront when query for readonly schema they created for me, as without putting it, I get error table not exist.</p>

<pre><code>--Connect to ui_prod_readonly
select * from ui_prod.table
</code></pre>

<p>I have project files which hardcode the sql query with only table names and adding owner name in front will cause many changes and effort. Can anyone explain me on this? or provide me any document/link to read. Thanks</p>