http://www.asprunner.com/forums/index.php?...amp;#entry33032
My last post was perhaps in wrong thread - sorry all.
The Sofa - you mentioned using Dynamic security - this looks possible, but I'm not sure. I look at ..uggroups - it has primary key of [groupid] - I need a two part key since my clients will be administering their own users' security rights (create new users, set their role(s), set roles permissions etc).
Each client may have different roles/permissions - e.g. one client may be very trusting and open - and let all their users be admins, whereas another may be very careful and restrict roles from certain things.
Also, table level security might be OK, but I want an end-user friendly method for its management by giving broader functional areas permissions, rather than on a table by table basis.
Any thoughts - anyone out there encountered similar challenges?