Hi,

I have two schemas A and B. How could i let B to view all procedures belonging to A schema by using toad?

Now i granted execute any procedures to B. But B just can view the package headers in TOAD. B needs to view the package bodies. How could I grant privileges?

Please help. Any idea is appreciated.