Security Access Permissions
Each record in the SecurityAccess table, defines a particular permission in the system, these permissions are assigned to the base roles. While moving around the system, the system will validate users have access to perform every operation by ensuring is assigned the property SecurityAccess. The System should check access by Title only.
SecurityAccess Table Column Name | Data Type | Nullable | Notes |
SAC_SecurityAccessID | INT | no | IDENTITY, PRIMARY KEY |
SAC_AccessTitle | NVARCHAR(100) | no | UNIQUE KEY |
SAC_AccessDescription | NVARCHAR(512) | no | |
SAC_HierarchySpecific* | BIT | no | Default 1 |
Notes: This is a
Readonly table, that should only be written when new permissions are added
Defined Access Titles