Table descriptions

users - stores the sahana user information

• username and their associated puuid if they are in the system
• password is stored encrypted

sys_user_groups - store the system based user groups

• this is currently mainly used for access control
• this group is different and separated from people groups on purpose

sys_access_rules - store the access rules created by the admin for allowing access to Sahana

• you can filter by user, group, role, action, module, machine IP
• leaving either of the columns above blank means it matches all for that field
• This is a priority based tables. The first accept or deny that matches in priority order wins

audit - keeps a log of all the changes to a particular entity

Relationships

sys_user_to_group - stores the access groups a user belongs to

• give the group ID and user (p_uuid) relations