Allow new user to access existing tables of a tablespace Oracle
<p>I have created a new user in Oracle and want to give full privileges to this user for a particular tablespace i.e. see all tables/views, select, update, delete etc. that exist in the tablespace (whether those tables/views are created by any user, I still want this new user to be able to have full access to them)</p>

<p>After creating the user like below</p>

<pre><code>create user WAS identified by WAS default tablespace TS_DDMS;
</code></pre>

<p>When I login into Oracle SQL developer with this new user, I dont see any existing tables/views that were created by other users/schemas even though I gave following permissions to this user.</p>

<pre><code>grant connect to WAS;
grant create any view to WAS;
grant create session to WAS; 
grant create view to WAS;
grant unlimited tablespace to WAS;
grant resource to WAS;
</code></pre>

<p>P.S: I can see the tables that I create with this user itself though.</p>