forms authentication and roles

[Phil Townsend]

I am integrating forms authentication in a web app which authenticates
users who are listed in a SQL Server table. There will be a small list
of application roles associated with each user and I would like to store
this list of roles in SQL as well. How would one go about this? Thanks!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Nicholas Paldino [.NET/C# MVP]]

Phil,

Are you using ASP.NET 2.0? If you are then I would take a look at the
SqlRoleProvider and the SqlMembershipProvider classes. They (along with a
number of other classes) work with the new user/roles framework that is
included in ASP.NET 2.0.

If you are not doing this, then you will have to create a class that
implements IPrincipal, where the implementation would get the roles for the
user from the database and return true or false from IsInRole when called
with a particular role.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Phil Townsend" <ph*******@yahoo.com> wrote in message
news:u4**************@TK2MSFTNGP11.phx.gbl...

I am integrating forms authentication in a web app which authenticates
users who are listed in a SQL Server table. There will be a small list
of application roles associated with each user and I would like to store
this list of roles in SQL as well. How would one go about this? Thanks!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!