Organizing groups and users
In Chapter 2, Developing Custom Applications, the User table was extended to create the home for the Guest records. It is generally a good idea to keep all your users in the User [sys_user] table, since it lets you use things such as notifications and Connect easily and effectively.
To organize users, put them into groups. Groups and users have a many-to-many relationship. One person can be a member of many groups, and a group can have many members.
Tip
Groups are stored in the sys_user_group table. The relationship between groups is stored in the Group Members[sys_user_grmember] table.
Groups are also hierarchical. A group has a reference field pointing to the group table, letting you build up a parent-child structure. ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access