SQL Server 2008 Access Levels -

i've 3 stored procedures -- sp1, sp2 & sp3.

sp2 , sp3 called within sp1.

if create dbrole (and user id) , provide exec access sp1 alone, , execute sp1, sp2 & sp3 gets executed without permission issues?

or need provide explicit execute access sp2 & sp3 ?

you need access them all, may use execute 'some other user' gain privileges other procedures:

msdn documentation