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

Last edited Feb 9, 2011 at 1:56 PM by mbulava, version 6

Comments

No comments yet.