sp803_auth_actual_parameters

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 sp800_user_roles (user_id, role_id)
foreign key (permission_parameter) references sp810_perm_param_seq (permission_parameter)
foreign key (parameter_type) references sp805_auth_parameter_types (parameter_type)
foreign key (assignment_type) references 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.