14.1 sp085_users
- Billy Sewell (Unlicensed)
Owned by Billy Sewell (Unlicensed)
Jan 26, 2024
Loading data...
This table provides details of each ServiceScheduling user's name, profile and printer location, together with the identifiers of the responsibility unit and work location (depot) to which the user has access.
If we need to change 14.1 sp085_users table definition, it is important to consider the impact of that change to the use of sp_ldap utlity and make appropriate changes in sp_ldap usage.
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
user_id | varchar2(50) | ||
| user_name | varchar2(50) | ||
| profile | varchar2(10) | ||
| resp_unit_no | number(4)(deprecated) |  | |
| resp_unit_ref | varchar2(8) (deprecated) | | |
| printer | varchar2(12) | | |
| password | varchar2(50) | | |
| enabled | number(1) | ||
| auth_type | varchar2(10) | ||
| category | number(3) | |
Keys
primary key (user_id)
foreign key (resp_unit_no, resp_unit_ref) references /wiki/spaces/SCH141/pages/27099986 (resp_unit_no, resp_unit_ref))
foreign key (profile) references 14.1 sp084_user_profiles (profile)
foreign key (category) references 14.1 sp089_user_categories (user_category)
Primary Key Referenced From
- 14.1 sp086_user_preferences
- sp087_user_derestrictions
- 14.1 sp088_user_units
- 14.1 sp255_user_teams
- 14.1 sp800_user_roles
Column Descriptions
| Field | Description |
|---|---|
| user_id | User identifier. |
| user_name | User's name |
| profile | User's profile |
| printer | User's printer location (obsolete, not supported within ServiceManager). |
| password | Gantt client password. If set the password supplied during a Gantt client logon must match it. If null the usual password should be supplied.. |
| enabled | Set to true (1) to enable this user to use ServiceManager; otherwise set to false (0) |
| auth_type | Authentication type – can only be set to 'SECURED' or 'LDAP' |
| category | user's category – system or standard |