View Single Post
  #8 (permalink)  
Old August 28th, 2011, 10:01 AM
Imar's Avatar
Imar Imar is offline
Wrox Author
Points: 72,073, Level: 100
Points: 72,073, Level: 100 Points: 72,073, Level: 100 Points: 72,073, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

When you run aspnet_regsql, the tool does all this for you. E.g. it creates the correct roles to which you can then assign the proper permissions.

If you decide to do this manually (although I wouldn't recommend it; I would try running aspnet_regsql against my target database again, or against a local database and then deploy the SQL scripts), take a look at files such as InstallMembership.sql in the folder C:\Windows\Microsoft.NET\Framework\v2.0.50727. You'll find examples of creating the roles and assigning the permissions to it.

Cheers,

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
Reply With Quote