Sunday, August 11, 2013

EXECUTE permission denied on object 'usp_login', database 'Database', schema 'dbo'


Please check your database user roles. It's necessary the database user to be owner. What you should instead do, is grant the user the following Roles: - aspnet_Membership_FullAccess - aspnet_Roles_FullAccess - etc. depending on what features you have enabled/installed into this database Do this by using Microsoft SQL Server Management Studio or Microsoft SQL Server Management Studio Express 1. Connect to the database you are working with 2. Open Databases 3. Open the database you are working with 4. Open Security 5. Open Users 6. Double-click the user who is accessing the database 7. In the list of Owned Schemas, check off the roles indicated above

0 comments:

Post a Comment