Users

Jace Benson

Table of content
  1. Key Fields
  2. User Types
  3. Groups and Roles
  4. Further Reading

Docs

The sys_user table is where every person who can log into your instance lives — employees, contractors, customers, even system accounts. It's one of the oldest and most extended tables on the platform.

Key Fields

Field Description
user_name Login name (must be unique)
name Display name (First Last)
email Email address
phone / mobile_phone Contact numbers
department Reference to sys_department
manager Reference to another sys_user
location Reference to cmn_location
roles Roles assigned directly to the user
active Boolean — is this user active?
web_service_access_only Boolean — API-only account?
ldap_server / source Where the user was imported from
password_needs_reset Boolean — force password change on next login

User Types

Groups and Roles

Users belong to groups (sys_user_grmember) and those groups are assigned roles. A user's effective role set is the union of their direct roles plus roles inherited through group membership.

Roles determine what a user can see and do. ACLs, UI Policies, and other access controls check these roles.

Further Reading