Re: EXECUTE permission denied on object... uh?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Hans Kesting (news.2.hansdk_at_spamgourmet.com)
Date: 07/07/04 

Date: Wed, 7 Jul 2004 14:37:20 +0200

"Jiggaz" <anonymous@discussions.microsoft.com> wrote in message news:28b1c01c46419$6faff8e0$a301280a@phx.gbl...
>Hi,

>In my ASPX Page, i have a form for signup. And whene user
>click on the button, the event Button1_Click must use a
>stored procedure.
>But instead of use stored proc, i get this exception :
>_____
>System.Data.SqlClient.SqlException: EXECUTE permission
>denied on object 'CreateAccount', database 'wizou', schema
>'dbo'. at [snip]

This means that the useraccount that is used to connect to SqlServer
has no execute permissions on the stored procedure "CreateAccount".
What user do you use? Do you specify it in the connectionstring
or do you use "windows authentication"?
(if windows authentication, then it's probably "ASPNET")

Check if that user really has execute permission on this SP.

Hans Kesting

Quantcast