Re: EXECUTE permission denied on object 'aspnet_CheckSchemaVersion

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_address> wrote in message
news:%23rNvun5fIHA.4744@xxxxxxxxxxxxxxxxxxxxxxx
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?




.

Relevant Pages

  • Re: owned schema or role members?
    ... but my question was more about the difference between Owned schema ... Is it enough to take db_anything in Role members or must the user also owns ... I want to create a login (for account ASPNET from the Active Directory) ... When addidng a new user to a specific database, ...
    (microsoft.public.sqlserver.security)
  • EXECUTE permission denied on object aspnet_CheckSchemaVersion
    ... I've created a database in Sql Server 2005 for my asp.net project. ... aspnet_regsql to add membership tables and stored procedures. ... 'Test', schema 'dbo'. ... aspnet_ should I enable these settings for this user or is there a better ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: owned schema or role members?
    ... SCHEMA and Roles are different things. ... Is it enough to take db_anything in Role members or must the user also ... I want to create a login (for account ASPNET from the Active Directory) ... When addidng a new user to a specific database, ...
    (microsoft.public.sqlserver.security)
  • Re: owned schema or role members?
    ... configuration two things about read /write: Owned Schema and Role members. ... Schema or in Role members or in both? ... I want to create a login (for account ASPNET from the Active ... When addidng a new user to a specific database, ...
    (microsoft.public.sqlserver.security)
  • Re: Java is becoming the new Cobol
    ... In the Unisys 2200 environment using their Network Database Server, you get a schema work area depending on how you invoke the schema. ... However, it not only copies the schema area into the program, but the "DMCA" (Database Management Communication Area - basically, the block of information that holds your connection state) is copied in too. ... So, you're left with working-storage, which makes it visible to your program only, or common-storage, which makes it visible to programs linked in. ...
    (comp.lang.cobol)