Message-Id: <10725.125453@fatcity.com> From: "Manasa Rao" Date: Fri, 29 Dec 2000 16:44:28 -0000 Subject: 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 >Reply-To: ORACLE-L@fatcity.com >To: Multiple recipients of list ORACLE-L >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 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@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@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@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@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@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). _________________________________________________________________