pl/sql objects are not displayed in object browser

[sagizvi]

pl/sqldeveloper users can't see pl/sql objects list and code using the object browser.
use dba views if available is on, and they have select any dictionary.
Which grants should the user have in order to view pl/sql (procedures, functions,stored procedures body/spec) ?
debug / execute is not a good idea..

 

[Marco Kalter]

If you have select privileges on the sys.all_objects view and sys.all_source view, you will see any PL/SQL Object for which you have execute privileges.

If you have select privileges on the sys.dba_objects view and sys.dba_source view, and if the "Use DBA views if available" option is enabled, you will see all PL/SQL Objects from these views.

Note that the selected user and selected filter of the Object Browser can still exclude objects.

 

[sagizvi]

Hi Marco
It seems to work when the user is not identified externally.
when i alter the user to be identified externally, and the user logins without user/pass (kerberos), it doesnt work.
looks like a bug..
Sagi

 

[Marco Kalter]

To obtain some more diagnostic information, can you modify the PL/SQL Developer shortcut and add the DebugSQL parameter? For example:

"C:\Program Files\PLSQL Developer 14\plsqldev.exe" DebugSQL

Reproduce the problem (open the "Procedures" folder) and send me the debug.txt file that is generated in the %APPDATA%\PLSQL Developer 14 directory (e.g. C:\Users\\AppData\Roaming\PLSQL Developer 14).