Role Assigment Permission table. This table specifies the roles that users with a particular assigning role are able to assign to other users.
Column Description(s):
Column Name | Column Type | Description |
ROLEASNPRM_ID |
INTEGER NOT NULL |
A generated unique key. |
ASSIGNING_ROLE_ID |
INTEGER NOT NULL |
Users with this role are able to assign the assignable role to other users. |
ORGENTITY_ID |
BIGINT NOT NULL |
Reserved for IBM internal use. |
ASSIGNABLE_ROLE_ID |
INTEGER |
The role that can be assigned to other users by users with the assigning role. |
OPTCOUNTER |
SMALLINT NOT NULL DEFAULT 0 |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
I0000967 |
ASSIGNING_ROLE_ID+ORGENTITY_ID+ASSIGNABLE_ROLE_ID |
Unique Index |
SQL050212031307480 |
ROLEASNPRM_ID |
Primary Key |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_1214 |
ORGENTITY_ID |
ORGENTITY |
ORGENTITY_ID |
Cascade |
F_1215 |
ASSIGNING_ROLE_ID |
ROLE |
ROLE_ID |
Cascade |
F_1216 |
ASSIGNABLE_ROLE_ID |
ROLE |
ROLE_ID |
Cascade |
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.