Group_Assignments Table

Authored by: rawdata on Saturday, March 29 2003 @ 06:54 PM EST

Just like with individuals, you can also assign one or more groups into another group. Everyone in the former groups would inherit the permissions of the latter group. I think ug_grp_id is used to help show this relationship.

For example, say you created a Gadget Group with a group id number of 50, and you want all Root users to be part of it. The ug_main_grp_id would be 50 representing the Gadget Group and the ug_grp_id would be 1 which is the group id number for Root.

[ Reply to This | # ]

Authored by: rawdata on Saturday, March 29 2003 @ 07:08 PM EST

I'm not sure if I used the right words to explain this. In the example I used, the Root users would belong and inherit all the permissions of the Gadget Group, but those who are members of Gadget would not inherit Root permissions. If multiple groups are added to Gadget, they do not inherit each others permissions. They only inherit the permissions of the group to which they are added.

[ Reply to This | # ]

Authored by: anuenue on Saturday, March 29 2003 @ 09:17 PM EST

So the relationship is the other direction. ug_grp_id inherits the rights of ug_main_grp_id.

Thanks

[ Reply to This | # ]