SQL Server: Creating a user database with permissions
Some Ideas (Anyone: please feel free to Edit/Add)
ApplicationPermissions (Application Level Permissions)

ApplicationID
PermissionID
Allow (Y/N/1/0)
Value (As in a Max Number of &quot;X&quot; allowed)
CreatedDate
CreatedByUserID
LastUpdatedDate
LastUpdatedByUserID

User_Application_Permissions (User Level Permissions)

UserID
ApplicationID
Allow (Y/N/1/0)
CreatedDate
CreatedByUserID
LastUpdatedDate
LastUpdatedByUserID

UserPermissions (Descriptive/Attribute Table)

PermissionID
PermissionDescription
CreatedDate
CreatedByUserID
LastUpdatedDate
LastUpdatedByUserID

Users (Descriptive/Attribute Table)

UserID
UserName
CreatedDate
CreatedByUserID
LastUpdatedDate
LastUpdatedByUserID