Permission group can have permission groups or permissions as its children
| Primary Key | Name | Type | Length | Precision | Can Be Null | Default | References | Action | Hints | Comment |
|---|---|---|---|---|---|---|---|---|---|---|
| true | PermissionGroupId | BIGINT | false | Identifies the permission group | ||||||
| false | ParentPermissionGroupId | BIGINT | true | IWA_PermissionGroup(PermissionGroupId) | ON DELETE SET NULL | Java , MsSqlServer | References the parent permission group of this permission group. | |||
| false | Name | VARCHAR | 200 | false | Name of the permission group |
| Constraint | Name | Columns | Hints | Comment |
|---|---|---|---|---|
| UNIQUE | UQ_Name | Name | MsSqlServer , MySql , Oracle |
| Name | Columns | Hints | Comment |
|---|---|---|---|
| IWA_PermissionGroup_ParentPermissionGroupId | ParentPermissionGroupId |
| Foreign Table | Column | Comment |
|---|---|---|
| IWA_PermissionGroup | ParentPermissionGroupId | References the parent permission group of this permission group. |
| IWA_SecurityDescriptorType | RootPermissionGroupId | References the root permission group of the security descriptor type. A security descriptor of this type can administrate all permissions that are referenced through this permission group |
| IWA_PermissionGroupPermission | PermissionGroupId | References the permission group |
| Object | Strategy |
|---|---|
| IWA_PermissionGroup | ALL |
| Object | AsParent |
|---|---|
| ParentPermissionGroupId | true |
| Object | NoReferenceUseTrigger | NoUnique |
|---|---|---|
| ParentPermissionGroupId | true | |
| UQ_Name | true |
| Object | NoUnique |
|---|---|
| UQ_Name | true |
| Object | NoUnique |
|---|---|
| UQ_Name | true |