sp085_users

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 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 sp058_responsibility_units (resp_unit_no, resp_unit_ref))
foreign key (profile) references sp084_user_profiles (profile)
foreign key (category) references sp089_user_categories (user_category)

Primary Key Referenced From

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