> Given SP-A and SP-B
>
> SP-A excutes SP-B
>
> User1 is granted execute on SP-A.
>
> Does one grant execute on SP-B to USER1 or SP-A or both?

Try it.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com