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_CheckSc hemaVersion', 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]

Re: EXECUTE permission denied on object 'aspnet_CheckSc hemaVersion

Okay, I've solved it. I added the user to these roles:
aspnet_Membersh ip_FullAccess
aspnet_Personal ization_FullAcc ess
aspnet_Profile_ FullAccess
aspnet_Roles_Fu llAccess
aspnet_WebEvent _FullAccess

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


"Jeff" <no_email_addre sswrote in message
news:%23rNvun5f IHA.4744@TK2MSF TNGP06.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_CheckSc hemaVersion', 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?
>
>