I can't see another user's package body.

[arturwp]

Hi,

I can see another user's package specification, but I can't see package body.
I have select privileges on the dba_objects and dba_source views.
The "Use DBA views if available" preference is enabled.

I can see package body only when I have DEBUG privilege on it. But this is not an acceptable solution.

PL/SQL Developer Version 13.0.3.1902

--
Artur

 

[Marco Kalter]

Can you query the dba_objects and dbs_source views and check if the records for this package body are returned?

 

[arturwp]

Today it works.
I think after set "Use DBA views if available" preference it is not enough to "Refresh data" on Object Browser, but you need to restart PL/SQL Developer.
Problem solved.

--
Artur

 

[SebG]

When you grant rights, you must disconnect and reconnect to Oracle.

 

[arturwp]

I don't grant new rights, only change preference in PL/SQL Developer.