Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  nested groups

Author  Topic  robertgr Starting Member 1 Post Posted - 2002-11-10 : 23:40:38 Hello I am trying to set up an sql security scheme using user groups which I am defining myself. each row in the db will have a user group associated with it. This is straight forword. Now I need to include other groups in the groups so that for example system administrators are inlcluded in all groups. system name: Widgets company: Acme Table: User_Groups user_group_id user_group_name 1 Widgets-Acme-G-East 2 Widgets-Acme-G-North Table: User_User_Group_Map user_id user_group_id 1 1 2 1 3 2 3 3 Here is the tree which I wish to implement. Is there an way to include these as groups and somehow drill down to get the user names? Widgets-System-Administrator (group name) - */Acme Widgets-Acme-G-East (group name) - Wdgets-Acme-All (group name) - Widgets-System-Administrtrator (group name) * bob admin/Acme (member) * widgets-system-administrator (group name) */Acme (member) - Widgets-Acme-General (group name) - Widgets-Acme-general-Readers (group name) * jane reader/Acme (member) * linda reader/Acme (member) - Widgets-Acme-General-Editors (group name) * paul editor/Acme (member) - Widgets-Acme-East //group name - Widgets-Acme-East-Readers (group name) * karen reader/Acme (member) * isabelle reader/Acme (member) - Widgets-Acme-East-Editors (group name) * zoe editor/Acme (member) Widgets-Acme - Widgets-System-Administrator (group name) - Widgets-Acme-General (group name) - Widgets-Acme-East (group name) - Widgets-Acme-South (group name) - Widgets-Acme-West (group name) - Widgets-Acme-North (group name) thank you for any advice