Security Descriptor Types
| Primary Key | Name | Type | Length | Precision | Can Be Null | Default | References | Action | Hints | Comment |
|---|---|---|---|---|---|---|---|---|---|---|
| true | SecurityDescriptorTypeId | BIGINT | false | Identifies the security descriptor type. | ||||||
| false | RootPermissionGroupId | BIGINT | false | IWA_PermissionGroup(PermissionGroupId) | MsSqlServer , MySql | 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 | ||||
| false | Name | VARCHAR | 200 | false | Name of the security descriptor type |
| Constraint | Name | Columns | Hints | Comment |
|---|---|---|---|---|
| UNIQUE | IWA_SecurityDescriptorType_NameIndex | Name |
| Name | Columns | Hints | Comment |
|---|---|---|---|
| IWA_SecurityDescriptorType_RootPermissionGroupId | RootPermissionGroupId |
| Foreign Table | Column | Comment |
|---|---|---|
| IWA_SecurityDescriptor | SecurityDescriptorTypeId | References the security descriptor type that this security descriptor belongs to. |
| Object | Strategy |
|---|---|
| IWA_SecurityDescriptorType | ALL |
| Object | NoReferenceUseTrigger |
|---|---|
| RootPermissionGroupId | true |
| Object | NoReferenceUseTrigger |
|---|---|
| RootPermissionGroupId | true |