SQL Server User Rights required to use the Ent Lib Jan 2006 Data Access Application Block

Topics: Data Access Application Block
Mar 12, 2007 at 2:15 AM

I'm using the Ent Lib January 2006 Data Access Application Block in an application, and am using Integrated Security to connect to a SQL Server 2000 database.

What is the minimum security in SQL Server that I need to give a user to enable them to use the application?

I've tried adding them to "Public" and they get a schema lookup error message, but if I add them to "db_owner" they can use the application fine.

I tried to search for some documentation, but couldn't find any.

Any pointers appreciated.



Mar 12, 2007 at 5:29 AM
A bit more information that I thought would be relevant.

This is a winform application.

My database has the ASPNETMEMBERSHIP and ASPNETPROFILE roles in them, so I have run the aspnet_regsql tool at some point in time.

I can see that I need to map users to these roles, and from some research, I at least need to put users into the

  • aspnetmembershipbasicaccess
  • aspnetpersonalizationbasicaccess
  • aspnetprofilebasicAccess
  • aspnetrolesbasicAccess

Am I supposed to do something like make the 'public' role inside the database a member of these four groups?