Relationship of users and groups 32
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-17-2023 07:36 AM
How users are related to groups , ?
Means
Many to many or one to many ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-17-2023 07:48 AM
Hi @Ashok Kumar ,
Groups and users have many-to-many relationship. A user can be a member of multiple groups, and a group can contain multiple users.
If my answer has helped with your question, please mark it as correct and helpful
Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-18-2023 04:29 AM
Hello,
Please refer below links.
https://www.servicenow.com/community/itom-forum/how-are-users-related-to-groups-or-roles/m-p/982928
Regards,
Namrata
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-18-2023 04:39 AM
Hello @Ashok Kumar
Users table (sys_user) and Groups table (sys_user_group) have a many-to-many relationship. Multiple users can be part of a single group, a single user can be part of multiple groups. The users and groups are linked to each other on Group Members table (sys_user_grmember).
If my answer helped you, please mark my answer as correct and helpful.
Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-18-2023 04:44 AM
Users table and Groups table have a many-to-many relationship. Groups must be related to roles.