Home » Developer & Programmer » Designer » Database design (Oracle, 9i,windowsXp)
Database design [message #297765] Sun, 03 February 2008 09:59 Go to next message
srikantbiswal
Messages: 3
Registered: November 2007
Location: Bhubaneswar
Junior Member
Plese help me,

In a table contains information about a company.There are different information about different department.A user from a department only access his department information. But a adminstrator of the company belongs to any department of the company access all the information of every department.

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

userType: ordinaryUser,Adminstrator

My question is how ordinary user can access same department information only.But adminstrator acess all dept information.
What are the constraints to design the above database
Re: Database design [message #297768 is a reply to message #297765] Sun, 03 February 2008 10:59 Go to previous message
Frank
Messages: 7901
Registered: March 2000
Senior Member
One way to do this is by applying fine grained access control (Google that if you don't know it).
You can also Google for rowlevel security in oracle for some extra explanations and/or options.
Previous Topic: capture PL/SQL packages
Next Topic: Application data purging
Goto Forum:
  


Current Time: Thu Mar 28 15:37:41 CDT 2024