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?
Jeff - 06 Mar 2008 16:09 GMT
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...
> asp.net 3.5
>
[quoted text clipped - 13 lines]
>
> any suggestions?