We've updated the ServiceNow Community Code of Conduct, adding guidelines around AI usage, professionalism, and content violations. Read more

Relationship of users and groups 32

Ashok  kumar
Tera Contributor

How users are related to groups , ? 

Means 

Many to many or one to many ?

 

4 REPLIES 4

Karan Chhabra6
Mega Sage

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!

Mayank Das
Tera Contributor

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!

Jose Alexandre
Tera Contributor

Users table and Groups table have a many-to-many relationship. Groups must be related to roles.