Do not try to do something too complex, I've been to a
client where they had create a role for each job
description in the company and each role was accessing
only the tables it needed.
People were changing job in the company and the job
description was evolving.
Also, they were 2 major restructurations in the same
year, it was a nightmare to manage.
- Manasa Rao <rao_manasa_at_hotmail.com> a écrit : >
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
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Manasa Rao
> INET: rao_manasa_at_hotmail.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com
Do You Yahoo!?
Received on Fri Dec 29 2000 - 08:13:46 CST