What SQL Server role do you pick for a normal user for ASP.NET Membership?
I used Integrated Security for a database connection for the first time for a website. The website pool uses Network Service as a user. I added Network Service as a SQL Server user mapped to public, then allowed it access to my database as websiteuser
. There are many aspnet_... roles to choose from. Any links out there that explains which ones to use? Do I just check th开发者_如何学Pythonem all since there's only one login coming from the website?
see How To: Use Forms Authentication with SQL Server in ASP.NET 2.0, the section titled "Grant Database Access to Your Web Application Account". and here for roles, under "To grant permissions in the database"
精彩评论