The EXECUTE permission was denied on the object
Posted: Thu Dec 10, 2009 6:07 amI have an application that uses ODBC to access SQL Server 2008 but I get the error
Solution is to Grant Execute permissions
eg
GRANT EXECUTE ON [dbo].[sp_items_for_sale] TO [ASPNET]
when I start the appliaction.The EXECUTE permission was denied on the object
Solution is to Grant Execute permissions
eg
GRANT EXECUTE ON [dbo].[sp_items_for_sale] TO [ASPNET]