Table IWA_AccessControl

Access controls defines if a permission is granted or denied to a role or user

Columns

Primary Key Name Type Length Precision Can Be Null Default References Action Hints Comment
true AccessControlId BIGINT false Identifies the access control.
false SecurityDescriptorId BIGINT false IWA_SecurityDescriptor(SecurityDescriptorId) ON DELETE CASCADE Java , MsSqlServer , MySql References the security descriptor that this access control belongs to.
false PermissionId BIGINT false IWA_Permission(PermissionId) ON DELETE CASCADE References the permission that this access control grants or denies.
false GrantDeny BIT false This flag indicates if the permission is granted (1) or denied (0).
false SecurityMemberId VARCHAR 210 false IWA_SecurityMember(SecurityMemberId) ON DELETE CASCADE References the user that this access control grants or denies the permission to. Must be null if RoleId is not null.

Constraints

Constraint Name Columns Hints Comment
UNIQUE IWA_AccessControl_UniqueIndex SecurityDescriptorId , PermissionId , SecurityMemberId

Indexes

Name Columns Hints Comment
IWA_AccessControl_SecDescIdIdx SecurityDescriptorId MsSqlServer , MySql
IWA_AccessControl_SecMembrIdIdx SecurityMemberId
IWA_AccessControl_PermissionIdIdx PermissionId

Cache

Object Strategy
IWA_AccessControl ALL_REMOVE_UNUSED

Java

Object AsParent
SecurityDescriptorId true

MySql

Object IndexName NoReferenceUseTrigger
SecurityDescriptorId true
IWA_AccessControl_SecDescIdIdx IWA_AccessControl_SecurityDescriptorIdIndex

MsSqlServer

Object IndexName NoReferenceUseTrigger
SecurityDescriptorId true
IWA_AccessControl_SecDescIdIdx IWA_AccessControl_SecurityDescriptorIdIndex