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
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
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