what is the minimum access level on a sql server the asp.net membership need?

Question

for security reason, what is the minimum access level the asp.net membership user could have?

Answer 1

Based on my investigations over here: http://stackoverflow.com/questions/473060/asp-net-membership-deleteuser, the user would need SELECT and EXECUTE permissions.

Answer 2

Better to use the application roles provided in the database.

These are documented on MSDN in page "Roles and Views in the Application Services Database for SQL Server". This includes which operations require which role.

NB. You can also use SQL Management Studio to look at what is secured for each of the roles.