Toad World® Forums

Views used to query data dictionary in Oracle connections


#1

Are we accessing the dba_views to retrieve information from the Data Dictionary with Oracle connections? I would assume if the user doesn’t have access to these views, we’d defer to the all_views. Is this correct? Will we be exposing an option to use one or the other like we do in Toad?


#2

When you logon we run a block of code that determines if you have access to the DBA views you need. If you do not we have alternate queries that use the ALL_* views. So the application is already set for two sets of queries and chooses which to execute based on the logon privileges. There is an existing error regarding this in version 1.1.1 that is resolved in version 2.0.

Debbie