EXECUTE permission denied on object 'aspnet_CheckSchemaVersion

J

Jeff

asp.net 3.5

I've created a database in Sql Server 2005 for my asp.net project. I used
aspnet_regsql to add membership tables and stored procedures.

Then I added a login/user to this database. Default schema for this user is
dbo.

When I try to execute my asp.net webpage I get this error:
EXECUTE permission denied on object 'aspnet_CheckSchemaVersion', database
'Test', schema 'dbo'.

I see that there are several owned schema and role members starting with
aspnet_ should I enable these settings for this user or is there a better
approach... like maybe setting this user to be db_owner?

any suggestions?
 
J

Jeff

Okay, I've solved it. I added the user to these roles:
aspnet_Membership_FullAccess
aspnet_Personalization_FullAccess
aspnet_Profile_FullAccess
aspnet_Roles_FullAccess
aspnet_WebEvent_FullAccess

but I'm a bit worried if giving FullAccess is to much...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,983
Messages
2,570,187
Members
46,747
Latest member
jojoBizaroo

Latest Threads

Top