November 19, 2015 - 3:27 pm UTC
Reviewer: A reader
I believe grant debug can solve the OP's issue.
GRANT DEBUG ON <name of package> to <name of user>;
This should make the package body source be visible in ALL_SOURCE, which any user is likely to have access to.
Note SQL Developer 2.1 (which is a really old version) had a bug where it wouldn't show the package body even with grant debug. Only a problem with that product and that version.
November 20, 2015 - 2:13 am UTC
Thanks for the information. Neat solution
September 12, 2018 - 2:00 pm UTC
Reviewer: kulauk from UK
Would granting SELECT_CATALOG_ROLE to the user give them the ability to see the package source code?
As i understand it SELECT_CATALOG_ROLE gives read only access to DBA_% views which will include DBA_SOURCE.
What do you think?
September 17, 2018 - 5:24 am UTC
That is a solution but it seems overkill to me. Yes they get DBA_SOURCE but they get DBA_ everything else as well.