right click on packages

[stefanz]

I have a question regarding the options when I right click on a package or table:

when I have granted select catlog role and selected use dba_view, I can view the all objects definitions from the object browser.

When I right click on an object I can only view objects I have the privileges to view/use.
I expected to see the code/definitions even when doing this with select catalog role and dba views.
Is this intended or is there another setting to be able to view source directly with having to go to the object browser and select the object?

I changed CANames.sql in the install directory hoping this would help, unfortunately it did not help.

Stefan

 

[stefanz]

I think a found a solution here in the forum, the parameter OldNameResolve

As this is not documented in the manual:
Are there any restrictions or plans to remove this parameter?

Stefan

 

[Marco Kalter]

There are no plans to remove this option. Note however that the current method to resolve a name is to call the dbms_sys.dbms_utility.name_resolve() function. Version 7 and earlier queried the dictionary, which can lead to performance issues in Oracle10g and later.

 

[stefanz]

Yes, noted.
As far as I know, most performance related issues where related to changes in all_-views, as long as I use dba_-views I should be fine (at least I did not encounter any issues up to 11.2 yet, unlike others on this forum)