| Database design [message #297765] |
Sun, 03 February 2008 09:59  |
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  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
