SQL Developer Connection missing tables

[revilord]

Hi, I just installed SQL Developer and connected to the DB. I clicked on the plus sign next to Tables, Views, Indexes, etc. under the connection but I don't any db tables or anything. I can enter and run Query's and return results. Like I say I am really new to SQL developer. Is there something in the setup I missed.

 

[LKBrwnDBA]

Are you connecting as the owner of these tables?

If not, look under 'other users'.


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[revilord]

Connecting as 'owner'? I only have read access to the tables I am not the DBA. You're telling me this is a permission problem?? I was hoping this was some sort of weird configuration thing that SQL Developer needs to enable viewing of the table scheme.

 

[revilord]

My DBA believes this is a confriguration problem. I couldn't tell you either way. Still looking for answers

 

[LKBrwnDBA]

There is nothing to configure, if you logon as owner of the tables you can "see" them.

If you logon as another account but have "select" (or more) privileges on those tables, you will be able to "find" the table definitions under "other users > schema owner > tables".

PS: Otherwise Install/Re-Install the latest version of SQL Developer.






----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb