web application security data model

Last Post 13 Apr 2008 11:59 PM by SQLUSA. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

11 Apr 2008 05:17 AM
I am designing logical model for web application security module. I don’t think I got it right. I have attached logical model to this discussion. Please help me with perfect design.

1) Application consists of various modules
2) Each application screen (user interface/html) is assigned to a module
3) Each screen has its own functions (insert, update, delete, report, search,....)
4) Each user is assigned to a particular user group
5) Group has restricted access to assigned modules only
6) Group is granted access to particular screen function (within allowed modules ONLY)
7) User inherits module-screen-function access from his group definition
8) Need flexibility of giving extra screen function access to selected users (within allowed modules for his group)
9) Login audit
click to view my current modelmy email
New Member
New Member

13 Apr 2008 11:59 PM
Can you describe your HW/SW/Network setup?

On the database server side, are you going to use application roles? Schemas?

Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
SQL Server Training, SSAS, SSIS, SSRS: http://www.sqlusa.com/

Acceptable Use Policy