OraQA

A table contains information about a company. There is different information about different departments. A user from a department only accesses his department information. But an administrator can access the information of any department.

Example:

UserTable (userId, userName, userType, departmentId)
DepartmentTable (departmentId, departmentName, folderId)
FolderTable (folderId, folderName)

userType: ordinaryUser, Administrator

My question is how ordinaryUser can access same department information only. But administrator can access all department information? What are the constraints to design the above database?

Thanks.

Filed under General, Question. Follow any responses to this entry through this RSS 2.0 feed.