title: using sql server security roles in ASP.net
body: <p>I am building an Intranet(with asp.net c#) application which uses windows authentication.
  in my application there will be three roles. and these three roles will have different privileges in the sql server 2008 which will be connected with it.</p>
  
  <p>in the sql server 2008, i plan to create 3 different security roles which have different user privileges in the DB. i.e they will have different read write permission for different tables in the database.</p>
  
  <p>my question to you all are, is there a way for me to map the application roles to the sql server roles?</p>
  
  <p>i did do some research into this, but the information that i found was more regarding "creating a sqlserviceprovider"... which was not exactly what i was looking for.</p>
  
  <p>any suggestions, recommendations will be most welcomed.</p>
  
  <p>thanks
  adrian </p>