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

Browser not supported