Procedure - read permission
DB Version: Oracle 11gR2
OS: Linux
RAC: 5 nodes
Application user: PXPROD
Several developer would like to have view/read access to Procedure in an production Application schema, so they can compare production procedures with the Dev schema in TOAD.
NOTE: I created a view using FROM sys.obj$ o, sys.source$ s, sys.user$ UNION ALL FROM sys.obj$ o, x$joxfs s, sys.user$ but that did not help the users.
1. How would I grant view / read on all procedures in application schema, so they can user the TOAD utility to compare.
2. As a work around, I created a user just for this purpose - but the test did not work.