Hi Guys, In order to see all of the tables in our companies DB I have to go find the main sys account. Is there a way to default my connection so that it shows the other users tables?
A:
What do you mean by "see all of the tables"? Are you happy if you know they're there, or do you need to see their content. In the former case dba_tables should do. In the latter case it's a matter of the privileges assigned to you.
René Nyffenegger
2009-11-07 11:19:44
+1
A:
Any table that your connecting account has at least SELECT privileges on will show up in the "Other Users" node of the navigation tree. If the table does not show up there then it is a database permissions issue, not a SQL Developer configuration issue.
dpbradley
2009-11-08 12:18:15
A:
Change your connect to login as the main Sys user. Otherwise like dpbradley says you will have to go find them under the Other Users node.
Dougman
2009-11-08 17:29:22