sp800_user_roles

This tables represents the link between users within sp085_users and the authorisation roles (e.g. Service Resource, Service Resource Manager, or Planner) associated with them.

Table Definition

Field	Type	Default	Nullable
user_id	varchar2(50)
role_id	number

Keys

primary key (user_id, role_id)
foreign key (user_id) references sp085_users (user_id)
foreign key (role_id) references sp808_role_definition (role_id)

Primary Key Referenced From

sp803_auth_actual_parameters

Column Descriptions

Field	Description
user_id	User identifier.
role_id	Role identifier.