ROLEASNPRM

Role Assignment Permission table. This table specifies the roles that users with a particular assigning role are able to assign to other users.

Column Descriptions:

Name	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	Organization for which this role assignment privilege applies. This must be Root Organization (-2001).
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	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	ROLEASNPRM_ID	Primary Key
I0000967	ASSIGNING_ROLE_ID+ORGENTITY_ID+ASSIGNABLE_ROLE_ID	Unique Index
I0001284	ORGENTITY_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	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