Topics

User Functions

Events

There are no upcoming events

What's New

Stories last 2 weeks

No new stories

Comments last 2 weeks

No new comments

Trackbacks last 2 weeks

No new trackback comments

Links last 2 weeks

No recent new links

NEW FILES last 14 days

No new files

Welcome to Geeklog Thursday, April 24 2014 @ 03:31 PM EDT

Group_Assignments Table

Geeklog
  • Saturday, March 29 2003 @ 10:20 AM EST
  • Contributed by:
  • Views:
    3,279
Can someone explain how the column ug_grp_id is used? My current understanding of ug_main_grp_id and ug_uid is that the user ID specified in ug_uid is a member of the group specified in ug_main_grp_id. Is ug_grp_id used to assign members and rights of that group (ug_grp_id) to ug_main_grp_id?

The following comments are owned by whomever posted them. This site is not responsible for what they say.

  • 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.
  • Group_Assignments Table
  • 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.
  • Group_Assignments Table
  • 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