Subject Re: Stored Procedures & Grant
Author Syarzhuk Kazachenka
>Either SP-A must have execute access to SP-B (and everything else
>that is used) OR the user must. Either (or both) condition(s) will
>satisfy the security requirement, the choice depends on your
>requirements.

IIRC, in version 5, contrary to what documentation said, giving execute
rigghts to just the parent stored procedure didn't work. I have no idea if
that was fixed in 6.

Syarzhuk

Be healthy, stay wealthy...

Visit Belarusan Music Source - http://www.belmusic.net


_____________________________________________________________________________________
Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com