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_parameter | number | Â | |
permission_id | number | Â |
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
Field | Description |
---|---|
permission_parameter | References the actual parameter in sp803 to which this permission applies. |
permission_id | Permission identifier. |