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
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.