web application security data model

Last Post 13 Apr 2008 11:59 PM by SQLUSA. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
pccuser
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.

Requirements:
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
SQLUSA
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/
You are not authorized to post a reply.

Acceptable Use Policy