Document toolboxDocument toolbox

sp804_permission_parameters

A number of permissions within sp802_permission can specify the same parameter (for example FRU(FRU_ID.F) : R and FRU(FRU_ID.F).Team : ALL) so consequently it must be possible for those user parameters specified within sp803_auth_actual_parameters to be applied to all appropriate permissions. This table provides the appropriate linkage between sp803 and sp802.


 

Table Definition

Field
Type
Default
Nullable
permission_parameternumber (error)
permission_idnumber (tick)

Keys

primary key (permission_parameter, permission_id) 
foreign key (permission_id) references sp802_permission (permission_id) 
foreign key (permission_parameter) references sp810_perm_param_seq (permission_parameter)

Column Descriptions

FieldDescription
permission_parameterReferences the actual parameter in sp803 to which this permission applies.
permission_idPermission identifier.