Membership provider extension?

[Fabrizio]

Hello,

Ask advice for the better way in ASP.NET 2.0 to use the memebership provider
but extended with the capability to lookup tuned access right from a DB.
eg. Role = SalesManager then lookup for which Region(s) in a Database.
Consider that this is just a sample, being the number of occurrence in the DB
not predictable so build a different role for each region not the desired
approach.
Thanks for the suggestions.

 

[PeterKellner]

Hello,

Ask advice for the better way in ASP.NET 2.0 to use the memebership provider
but extended with the capability to lookup tuned access right from a DB.
eg. Role = SalesManager then lookup for which Region(s) in a Database.
Consider that this is just a sample, being the number of occurrence in the DB
not predictable so build a different role for each region not the desired
approach.
Thanks for the suggestions.

Not to go against what you already think is wrong, but I would create
the roles programatically as you need them. (since roles are also
just data in the database). That way, you get all the capabilities of
roles without having to extend your database.

You might also have a general role called something like "Sales
Managers" which you give to certain pages. Then, when you create new
users, they will get the privileges of sales managers in addition to
their own regions.

Good Luck,
Peter Kellner
http://peterkellner.net