Permissions on packages and package body

[Chintz]

What permissions would a user have to have to see packages and package bodies in other users schemas? I have granted the user 'execute any procedure' but that does not seem to fix the issue.

-Chintz

[Sameer]

Grant SELECT on DBA_SOURCE view, so that user will able to see package/body as well as source code...

[Chintz]

So for any user to see the package body they have to have select on dictionary view? Does that mean they can see all source code in all schemas?

-Chintz

[Chintz]

What kind of privilege is that? 'Select on dba_source' is not a system privilege?

-Chintz

[Sameer]

Yes, to avoid that you can create a view based on dba_objetcs which selects only package & package body names of userB

F.ex: userA needs to see package/body names of userB.

CREATE view User_B_Packages AS 
SELECT * FROM DBA_OBJECTS WHERE owner = 'USER_B'
AND object_type IN ('PACKAGE BODY', 'PACKAGE');

GRANT SELECT ON User_B_Packages to userA;

[Chintz]

So does that mean Oracle does not provide a permission that lets the user have privileges on packages and package bodies. I thought 'Execute any procedure' covers that.

-Chintz

[Sameer]

'Execute any procedure' permits user to execute perticular proc/package of other user.. not to see how many other procs/packages he has..