Security members can be user or roles
Primary Key | Name | Type | Length | Precision | Can Be Null | Default | References | Action | Hints | Comment |
---|---|---|---|---|---|---|---|---|---|---|
true | SecurityMemberId | VARCHAR | 210 | false | Identifies the security member. | |||||
false | Name | VARCHAR | 200 | false | Name of the security member. | |||||
false | MemberName | VARCHAR | 201 | false | Member Name of the security member. This is the Name and a '#' as prefix if the member is a user. | |||||
false | DisplayName | VARCHAR | 200 | true | Display name of the security member. | |||||
false | SecuritySystemId | BIGINT | false | IWA_SecuritySystem(SecuritySystemId) | References the security system this security member belongs to. | |||||
false | Enabled | BIT | false | 0 | Security member enabled (1) or disabled (0). | |||||
false | Type | INTEGER | false | Java | Member type: role (0) or user (1) |
Name | Columns | Hints | Comment |
---|---|---|---|
IWA_SecurityMemberNameIdx | Name | ||
IWA_SecurityMemberMemberNameIdx | MemberName | ||
IWA_SecurityMemberDisplayNameIdx | DisplayName | ||
IWA_SecurityMemberEnabledIdx | Enabled | ||
IWA_SecurityMemberTypeIdx | Type | ||
IWA_SecurityMember_SecuritySystemIdIndex | SecuritySystemId |
Foreign Table | Column | Comment |
---|---|---|
IWA_Role | SecurityMemberId | |
IWA_User | SecurityMemberId | |
IWA_Case | ActivatorId | References the security member who was set as start activator (user or role). |
IWA_Case | CreatorId | References the security member which has created this case. Maybe null if the user who created this case was an unknown user. |
IWA_Case | OwnerId | Owner Fields References a security member who owns this case. This field can be null. |
IWA_Task | WorkerId | References the security member that is working or has worked on this task. |
IWA_Task | ActivatorId | References the security member who can resume the task (user or role). |
IWA_Task | OriginalActivatorId | References the security member who originally was set as task activator (user or role). |
IWA_Task | ExpiryActivatorId | References the security member who can resume the task after the task has expired (user or role). |
IWA_WorkflowEvent | UserId | References the user that has driven the task or case which has triggered this event. Maybe null if event was triggered by an anonymous user. |
IWA_SignalEvent | SentById | |
IWA_AccessControl | SecurityMemberId | References the user that this access control grants or denies the permission to. Must be null if RoleId is not null. |
Object | Strategy |
---|---|
IWA_SecurityMember | ALL_REMOVE_UNUSED |
Object | Enum |
---|---|
Type | ch.ivyteam.ivy.security.internal.securitymember.SecurityMemberType |