Lesson 2
Users and Departments
In ServiceNow, users are associated with departments through a one-to-many relationship, meaning a user can belong to only one department and one company. The cmn_department table stores department information, and the sys_user table has a reference field to link users to their respective departments.
-
Users:
In ServiceNow, users are individual accounts with defined roles and permissions that allow them to access and interact with the platform.
-
Departments:
Departments represent organizational units within a company and are used to categorize users and manage access to specific resources or information.
-
Companies:
Companies can represent different organizations, vendors, or customers, and users can also be associated with a company.
- One-to-many: Each user can be associated with one department
- and one company.
- Reference fields: The
sys_usertable contains reference fields that link users to their corresponding department and company records in thecmn_departmentandcore_companytables, respectively.
How it Works:-
1. Department Creation:
Departments are created and managed within the
cmn_departmenttable-
including information like the department’s name, cost code, and manager.
-
2. User Creation:
When creating a new user, you assign them to a specific department and company.
-
3. User Access:
ServiceNow uses the department and company information to control user access to records, applications, and other resources based on predefined criteria.
Example:If you have a “Sales” department and a “Marketing” department, you would create these departments in thecmn_departmenttable. Then, when creating a user, you would assign them to either the “Sales” or “Marketing” department, depending on their role.
-