Error: "grantor does not have grant permission"

Hi all,

Before using SQL Server 2000 Developer Edition I did not get this error message. I had been using the trial edition of SQL Server 2000.

I only get it with stored procedures.

I solved my problem by giving the ASPNET login "db_owner" privs, which I didn't need to with the trial edition and is not best practice from a security angle.

I login under the Windows based admin account. (not using mixed mode).

Hope someone can shed some light.

Thanks.Placing a statement like:

"grant exec to dbo.testProc for {role}"

Inside the procedure can cause this problem, and was the culprit in this case.

Of course the ASPNET account (executing the sp) does not have grant permission!