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?

Richard · Answer 1 · 2009-06-08T12:40:35.470

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.

edited Jun 08 '09 at 12:40

answered Jun 08 '09 at 12:28

Richard

score 1 · Accepted Answer · edited May 23 '17 at 11:48

1

Based on my investigations over here: ASP.Net Membership.DeleteUser, the user would need SELECT and EXECUTE permissions.

edited May 23 '17 at 11:48

Community

answered Jun 08 '09 at 12:17

Irwin

2 Answers2