Re: ways to allow developers to see all packge bodies without EXECUTE ANY PROCEDURE?

2002-05-13 Thread Tim Gorman
Better to just create a new view called DEV_SOURCE? Owned by a TOAD account, not SYS? - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, May 13, 2002 4:58 AM EXECUTE ANY PROCEDURE? > I think I would just re-define all_source to include tha

Re: ways to allow developers to see all packge bodies without EXECUTE ANY PROCEDURE?

2002-05-13 Thread Mogens Nørgaard
I think I would just re-define all_source to include that priv. Just remember to re-run the definition after upgrades, perhaps. Mogens Jack Silvey wrote: >Good day listers, > >We have some developers that would like to see all the >package bodies in our data warehouse. This is a >reasonable re

ways to allow developers to see all packge bodies without EXECUTE ANY PROCEDURE?

2002-05-12 Thread Jack Silvey
Good day listers, We have some developers that would like to see all the package bodies in our data warehouse. This is a reasonable request. The developers use Toad, which used the ALL_SOURCE view. I pulled the code for all_source and discovered that the execute_any priv exclusion is hardcoded