﻿<?xml version='1.0' encoding='UTF-8'?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/"><channel><title>InstantASP Community Forums / Old Forums / InstantForum.NET 4.x / Suggestions &amp; Requests  / Group Membership and Permission Set Issues / Latest Posts</title><generator>InstantForum.NET v4.1.4</generator><description>InstantASP Community Forums</description><link>http://community.instantasp.co.uk/</link><webMaster>sales@instantasp.co.uk</webMaster><lastBuildDate>Fri, 09 Jan 2009 04:44:34 GMT</lastBuildDate><ttl>20</ttl><item><title>Group Membership and Permission Set Issues</title><link>http://community.instantasp.co.uk/Topic8371-51-1.aspx</link><description>1. We have many Member Groups &amp;gt; 50. &lt;P&gt;In Admin CP, when you assign &lt;STRONG&gt;Secondary Member Groups&lt;/STRONG&gt;, if you assign up to 41 groups to a member it's OK, but when you assign the 42th group the last one list (not necessary the 42th) becomes unassigned.&lt;/P&gt;&lt;P&gt;2. In the database model, there is a table InstantASP_UsersRoles with three columns:&lt;/P&gt;&lt;UL&gt;&lt;LI&gt;UserRoleID (int, autoincrement, primary key)&lt;/LI&gt;&lt;LI&gt;UserID (int)&lt;/LI&gt;&lt;LI&gt;RoleID (smallint)&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;Looking at the data model, I can see it it possible to have the same user twice assigned  the same role. I tried it manually by inserting a record in a table and it is possible. Of course you can prevent duplicates inside a code. It would be simpler and faster to select records if there were only two columns:&lt;/P&gt;&lt;UL&gt;&lt;LI&gt;UserID (int, part of primary key)&lt;/LI&gt;&lt;LI&gt;RoleID (smallint, part of primary key)&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;3. In Admin CP, Manage Members you have three fields:&lt;/P&gt;&lt;UL&gt;&lt;LI&gt;Primary Member Group&lt;/LI&gt;&lt;LI&gt;Secondary Member Group&lt;/LI&gt;&lt;LI&gt;Permission Set&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;Secondary Member Group list is used to define access to the forums and to define permissions to those forums. Permission Set list can replace the default permission set from Primary Member Group if set. Primary Member Group is used to define the default permission set and a group membership as well.&lt;/P&gt;&lt;P&gt;If you select Primary Member Group Membership the primary group does not appear on the list of Secondary Member Group. You can miss that if you start changing groups later on&lt;/P&gt;&lt;P&gt;An easier approach could be:&lt;/P&gt;&lt;UL&gt;&lt;LI&gt;Default Permission Set - defines default permission sets&lt;/LI&gt;&lt;LI&gt;Member Groups - defines access to the groups (forums)&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;To override default permission set per forum (for a user or a group) - this could be defined in Manage Forums.&lt;/P&gt;&lt;P&gt;Robert</description><pubDate>Wed, 07 Sep 2005 10:10:51 GMT</pubDate><dc:creator>rooobce</dc:creator></item></channel></rss>