14.1 sp087_user_derestrictions
- Billy Sewell (Unlicensed)
This table defines which users may have access to which restriction types. A user may have multiple entries if access is granted to more than one restriction type.
If the system has been configured to support restricted jobs and the gantt user has been given access to a restriction type, then the gantt user will be able to view data that has been configured as sensitive on jobs which have been booked with that restriction type. If the gantt user has not been assigned the restriction type then they will not be able to view sensitive data.
User derestrictions can be set up through ServiceManager which uses the external UpdateUserDerestrictionAPI.
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
| user_id | varchar2(50) |  | |
| restriction_no | number(9) | |
Keys
primary key (user_id,restriction_no)
foreign key (restriction_no) references sp073_restriction_types (restriction_no)
foreign key (user_id) references sp085_users (user_id)
Column Descriptions
Field | Description |
|---|---|
| user_id | Is the reference to the user who has access to jobs with the restriction no |
| restriction_no | Is the restriction no for the jobs that the gantt user has access to |