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.