The EXECUTE permission was denied on the object

The EXECUTE permission was denied on the object

Postby stephen » Thu Dec 10, 2009 6:07 am

I have an application that uses ODBC to access SQL Server 2008 but I get the error
The EXECUTE permission was denied on the object
when I start the appliaction.
Solution is to Grant Execute permissions
eg

GRANT EXECUTE ON [dbo].[sp_items_for_sale] TO [ASPNET]
stephen
 
Posts: 507
Joined: Thu Feb 09, 2006 9:37 am
Location: Brisbane

Return to SQL Server Help

Who is online

Users browsing this forum: No registered users and 2 guests

cron