K. Brian Kelley (10/3/2009)
You should always try to grant permissions to a role you've created and then put the appropriate users in that role. If you also want the role to have execute rights on all stored procedures as well, you can simply:
I know its a best practice, thanks. i'll do the same from now onwards.
and thanks for the help Sir [:)]
Regards,
Sarabpreet Singh 😎
Sarabpreet.com
SQLChamp.com
Twitter: @Sarab_SQLGeek