EXECUTE permission denied on object 'aspnet_CheckSchemaVersion

[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?

[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...
"Jeff" <no_email_addresswrote in message
news:%2****************@TK2MSFTNGP06.phx.gbl...

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?