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


sys_user_to_group - stores the access groups a user belongs to

  • give the group ID and user (p_uuid) relations

QR Code
QR Code sql:security (generated for current page)