DBA views not always used in v8

Qkxy

Member²
Hi,
In version 7 when I type a package name in the SQL editor in schema.package format and I right click on it the context sensitive menu has option to view, edit, drop or browse that package.
In version 8.0.2 this function is not working when I not have direct grant on the package, but in the browser I can find the package and I can view it because I have select grant on dba_% views (Use DBA Views if available option is checked).
Can you fix this?
 
Hi Marco,

Could this also be related to thread "Compare objects with only select_catalog_role on target user" ? Select_catalog gives select access to all DBA view.
 
Back
Top