Print Thread
{bug} unable to see other user's procs/funcs
#28374 11/02/07 08:52 PM
Joined: May 2003
Posts: 118
B
Babo Offline OP
Member
OP Offline
Member
B
Joined: May 2003
Posts: 118
seems like a bug to me.
create user a ...
grant create session to a
grant select_catalog_role to a ;
grant debug any procedure to a ;
grant select any dictionary to a ;
grant select any table to a ;

this should give me not only read access to other user's tables/indexes , but procs and functions.
For some reason it doesn't.
latest pl/sql developer.
thank you.

Re: {bug} unable to see other user's procs/funcs
#28375 11/05/07 10:51 PM
Joined: Aug 1999
Posts: 22,210
Member
Offline
Member
Joined: Aug 1999
Posts: 22,210
Maybe you need to enable the "Use DBA views if available" option (Tools > Preferences > Oracle / Options).


Marco Kalter
Allround Automations
Re: {bug} unable to see other user's procs/funcs
#28376 11/07/07 06:58 PM
Joined: May 2003
Posts: 118
B
Babo Offline OP
Member
OP Offline
Member
B
Joined: May 2003
Posts: 118
that fixed the problem.
thank you, Marco.


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.036s Queries: 14 (0.012s) Memory: 2.4996 MB (Peak: 3.0378 MB) Data Comp: Off Server Time: 2024-05-06 17:01:46 UTC
Valid HTML 5 and Valid CSS