Unable to view all objects
traceyDec 15 2009 — edited Dec 22 2009I 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