0

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)

After creating the user like below

create user WAS identified by WAS default tablespace TS_DDMS;

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.

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;

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

WAQ
  • 2,556
  • 6
  • 45
  • 86
  • Tables, views, stored procedures and many other database objects are schema objects (own by a user\schema). SQL Developer shows you database objects that you own. To be able to access objects owned by another user(schema), that other user has to give you appropriate object privileges. – Nick Krasnov Dec 06 '16 at 12:00
  • How? please specify? – WAQ Dec 06 '16 at 12:03
  • [There you go](https://docs.oracle.com/cd/E21901_01/timesten.1122/e21642/privileges.htm#TTSQL338) or/and [this one](https://docs.oracle.com/cd/B19306_01/network.102/b14266/admusers.htm#i1009117) – Nick Krasnov Dec 06 '16 at 12:08
  • @NicholasKrasnov I still can not see tables created by other user/schemas. – WAQ Dec 07 '16 at 07:21
  • I did `grant all privileges to WAS;` and it worked fine. – WAQ Dec 07 '16 at 09:31
  • Then you should be able to see other users objects when you expand "Other Users\<>". Those objects will not be displayed when you are browsing your own schema. – Nick Krasnov Dec 07 '16 at 09:36

0 Answers0