14.1 sp801_role_permissions

A role can have a number of permissions associated with it. A permission is the right to perform operation Y on object Z. This table provides the link between the defined role (sp808_role_definition) and its permissions (sp802_permission).

Table Definition

Field	Type	Default	Nullable
role_id	number
permission_id	number

Keys

primary key (role_id, permission_id)
unique (permission_id)
foreign key (role_id) references 14.1 sp808_role_definition (role_id)
foreign key (permission_id) references 14.1 sp802_permission (permission_id)

Column Descriptions

Field	Description
role_id	Role identifier.
permission_id	Permission identifier.