Re: Oracle database design question.

Oh, I wish my client understood that, I need a very good business case to support that.

I definitely appreciate your suggestion. Thanks
Radhika

>From: paquette stephane <stephane_paquette_at_yahoo.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: Oracle database design question.
>Date: Fri, 29 Dec 2000 06:15:22 -0800
>
>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!?
>Yahoo! Photos - Share your holiday photos online!
>http://photos.yahoo.com/
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: =?iso-8859-1?q?paquette=20stephane?=
> INET: stephane_paquette_at_yahoo.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).