Oracle database design question.

From: Manasa Rao <rao_manasa_at_hotmail.com>
Date: Fri, 29 Dec 2000 12:33:18 -0000
Message-Id: <10725.125441@fatcity.com>

All,

For our Workers Injury Compensation database, customer visions to secure the data based on the type of role in the company and based on their geographical location.

Question is how do you limit the data based on their geographical location?

And an employee can have 13 geographical locations.(Area, DistrictCode, FinanceNumber, Paylocation etc…) And there is a table for the geo location that ties to the employee table, and has one record for every employee in the company.

And an employee requests for authorization, at the time of joining the company which is how I know what geographical data he could see. But, how do I give roles and privileges based on this? And we are using Fine Grain Access Control of Oracle 8I for security designing.

Any suggestions are appreciated.

Thanks
Manasa.

Get your FREE download of MSN Explorer at http://explorer.msn.com Received on Fri Dec 29 2000 - 06:33:18 CST