Skip to Main Content

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!

Unable to view all objects

traceyDec 15 2009 — edited Dec 22 2009
I am trying to discourage my support team and developers from logging on as the schema owner, and giving them all their own userids. The issue we are having is that they cannot see all of the schema objects when they log on as themselves. They all have read only access to the tables, so they can go to 'Other users', 'shchema name' and list all of the tables but they cannot see indexes, and they can only see a subset of the sequences that are owned by the schema.

If they log on using their own userids to TOAD, they can see everything they need to see, including procedures, functions etc., so I think the issue could be that sql developer uses all_ views whereas toad uses dba_ views to list objects.

Is there anything I can do to give individuals access to view all objects owned by a schema, or do I need to migrate them onto TOAD?

Thanks

Tracey
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 2 2020
Added on Dec 15 2009
12 comments
2,900 views