title: table name includes the schema name of another user
body: <p>I was running a script on the database that grants execute on all tables for the user 'R_USER' to the 'APP_WRITER' user. I received a &quot;table or view does not exist&quot; error.</p>
  <p>to debug I put an dbms_output.putline(r.TABLENAME).</p>
  <p>I noticed the problem is that there is a table on the R_USER with the name= 'USER_ARCH.LOGS', there is a schema in the database for the USER_ARCH, so there is this ambiguity.</p>
  <p>My question is, how do I drop the 'USER_ARH.LOGS' table in the R_USER schema and not the USER_ARCH schema?</p>
  <p>As simply using drop table USER_ARH.LOGS will try to drop the wrong table and give me an &quot;insufficient privileges&quot; error.</p>