-
1. Re: Identity module constraint needed
dmlloyd May 7, 2007 10:23 AM (in response to dmlloyd)"david.lloyd@jboss.com" wrote:
It looks to me like there ought to be a unique constraint across either the GROUP_ and ROLE_ columns or just the GROUP_ column within the identity JBPM_ID_MEMBERSHIP table.
I misstated - I mean across USER_, GROUP_, and ROLE_, or just USER_ and GROUP_. -
2. Re: Identity module constraint needed
tom.baeyens May 16, 2007 9:26 AM (in response to dmlloyd)i think you can have multiple people in the same group with the same role. e.g. many people could have the developer role in a team
or did you mean something else ? -
3. Re: Identity module constraint needed
dmlloyd May 26, 2007 12:57 PM (in response to dmlloyd)I meant to say that any given user cannot be in the same group more than once. Though a single group can certainly contain more than one user.
-
4. Re: Identity module constraint needed
tom.baeyens May 26, 2007 3:40 PM (in response to dmlloyd)i don't think that is a general constraint. i mean, most of the times, a user will only have 1 membership, but i guess that sometimes people can fullfill 2 roles for one group.
-
5. Re: Identity module constraint needed
kukeltje May 27, 2007 9:57 AM (in response to dmlloyd)Yes, 2 roles for one group occurs lots of times in the business we are in. They are manager of the group, but also do the normal regular work
-
6. Re: Identity module constraint needed
dmlloyd May 27, 2007 10:04 AM (in response to dmlloyd)What about limiting each user to only belong to each group one time for each distinct role?
So a user cannot be in the same group with the same role more than once. This way, if roles are not used, then the user will be limited to being in the group only one time, but if they are, then they are prevented from being in the same role more than once.