Print Thread
pl/sql objects are not displayed in object browser
#62829 01/06/22 07:29 AM
Joined: Nov 2007
Posts: 53
Tel Aviv,Israel
S
sagizvi Offline OP
Member
OP Offline
Member
S
Joined: Nov 2007
Posts: 53
Tel Aviv,Israel
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..


Sagi Zvi
Re: pl/sql objects are not displayed in object browser
sagizvi #62830 01/06/22 10:47 AM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
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.


Marco Kalter
Allround Automations
Re: pl/sql objects are not displayed in object browser
sagizvi #62839 01/09/22 08:15 AM
Joined: Nov 2007
Posts: 53
Tel Aviv,Israel
S
sagizvi Offline OP
Member
OP Offline
Member
S
Joined: Nov 2007
Posts: 53
Tel Aviv,Israel
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


Sagi Zvi
Re: pl/sql objects are not displayed in object browser
sagizvi #62840 01/10/22 09:44 AM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
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\<User>\AppData\Roaming\PLSQL Developer 14).


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.054s Queries: 14 (0.026s) Memory: 2.5065 MB (Peak: 3.0394 MB) Data Comp: Off Server Time: 2024-05-17 14:30:20 UTC
Valid HTML 5 and Valid CSS