SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Tables not showing in tables node under connection

510375May 2 2006 — edited Mar 30 2007

First of all I would like to say, I just starting using SqlDeveloper and it is a pretty slick tool.

Here is my issue:
I am doing some development work on a database for another group. That group has a login and all their tables were created with that login i.e. that login is the owner of their tables.

Their login has many privileges they don't want me to have access to so our dba has created a separate login id for me. When the other guys use their login to create a connection in SqlDevlepor the tables node is fully populated with all their tables. This is helpful as it gives you a nice quick graphichal view of tables, columns, indexes etc.

When I login with my user ID the tables node is empty when I expand it. I had our dba create a synonymn on one of the tables as a test hoping that might help but no luck. Does anybody have an idea how/if I can get the graphical view of these tables?

Thanks in advance for any help, and my aplogies if I am missing something obvious I am new to Oracle (been doing mostly Sybase and MS SqlServer).

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 27 2007

Added on May 2 2006

#sql-developer

4 comments

1,650 views