14.1 sp803_auth_actual_parameters
- Billy Sewell (Unlicensed)
When a role is assigned to a user, all the parameters (e.g. FRU, Team, or Operative) specified within the permissions associated with that role must be instantiated with valid values. This table contains those actual parameter values. During initialisation a user's actual parameters are read from this table and applied to the sp802_permission entries associated with each role assigned to the user.
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
| user_id | varchar2(50) |  | |
| role_id | number | | |
| parameter_type | varchar2(20) | | |
| name | varchar2(20) | | |
| assignment_type | varchar2(2) | | |
| value | varchar2(50) | | |
| permission_parameter | number | |
Keys
primary key (user_id, role_id, parameter_type, name, assignment_type, value, permission_parameter)
foreign key (user_id, role_id ) references 14.1 sp800_user_roles (user_id, role_id)
foreign key (permission_parameter) references 14.1 sp810_perm_param_seq (permission_parameter)
foreign key (parameter_type) references 14.1 sp805_auth_parameter_types (parameter_type)
foreign key (assignment_type) references 14.1 sp807_assignment_param_ops (assignment_type)
Column Descriptions
| Field | Description |
|---|---|
| user_id | User identifier. |
| role_id | Role identifier. |
| parameter_type | Must be a valid parameter type as specified in fs186 (i.e. FRU, Team, Oper, SA or App). |
| name | Name of the ServiceOptimizer application for which the authorisation applies. (Not used as the current implementation is only for ServiceManager). |
| assignment_type | Defines whether the actual parameter is either inclusive or exclusive. |
| value | Actual value of this parameter (e.g. FRU name, Team name, etc). |
| permission_parameter | Defines which permission(s) this actual parameter applies to. |