Table IWA_RoleProperty

Role Properties

Columns

Primary Key Name Type Length Precision Can Be Null Default References Action Hints Comment
false SecurityMemberId VARCHAR 210 false IWA_Role(SecurityMemberId) ON DELETE CASCADE Java References the user this property belongs to.
true RolePropertyId BIGINT false Identifies the user property
false PropertyName VARCHAR 255 false Oracle Name of the property.
false PropertyValue CLOB false Java Value of the property.

Constraints

Constraint Name Columns Hints Comment
UNIQUE RoleProperty_SecMemberIdPropertyNameIndex SecurityMemberId , PropertyName

Indexes

Name Columns Hints Comment
IWA_RoleProperty_SecurityMemberIdIndex SecurityMemberId

Cache

Object Strategy
IWA_RoleProperty ALL_REMOVE_UNUSED

Java

Object AsParent DataType
SecurityMemberId true
PropertyValue String

Oracle

Object ConvertEmptyStringToNull
PropertyName true