Re: Oracle database design question.

What about coming up with a cost for maintaining (changing) the roles and privileges? When you come up with a price, you will usually get someone's attention.

• Manasa Rao <rao_manasa_at_hotmail.com> wrote:
  > 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).
  >
  >

  ---

  
  > 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