Reference > Database > WebSphere Commerce database tables > R
WebSphere Commerce database table: 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 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.
Indexes Index Name Indexed Column Names Index Type I0000967 ASSIGNING_ROLE_ID+ORGENTITY_ID+ASSIGNABLE_ROLE_ID Unique Index SQL100520030424990 ROLEASNPRM_ID Primary Key I0001284 ORGENTITY_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names 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 _vcc_freeselect_bottom_