package body text for other users

[hitenderk]

How to let users see the package body text from like all_source etc. ?
I have given execute rights to the users on procedure and packages. The users can see the text from all_source on procedure and package specifications but not the package body. The public synonyms have also
been created .

[jmodic]

What Oracle version?

I've just tried it on my 8.1.7 and I can see the source of package bodies of other schemas that has been granted execute to me from ALL_SOURCE.

SELECT * FROM all_source WHERE type = 'PACKAGE BODY' AND owner = 'SOMEOTHERSCHEMA";

[Edited by jmodic on 07-09-2001 at 10:11 AM]

[hitenderk]

The execute rights were given directly to user as well as to ROLE( which is granted to the user). It does not let the user see package body in 8.0.5.

[jmodic]

Yeah, you are right! I've checked it on 8.0.5 and you realy can't see the source of the package body granted to you in ALL_SOURCE. Obviously they've changed that somewhere in between 8.05. and 8.1.7....

[Zaggy]

Give them the role "SELECT_CATALOG_ROLE" and see if they can read it from dba_source, that is if you want them to have this role.

[hitenderk]

I do not want them to query dba_source only the all_source.