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 .