Re: Oracle database design question.

Especially if you have multiples environments, here we have :
development
dev-test 1
user-test
pre-production
production
maintenance

• David Nemeht <dpn_ora_at_yahoo.com> a écrit : > 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
  > > (like subscribing).
  >
  >
  > __________________________________________________
  > 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
  >
  === message truncated ===