Re: Here's a poser...any takers???

You didn't go into what your front end was to this scenario. Are you creating individual db accounts for each person? Are you letting some piece of software use the company account to login? ... it basically depends on the architecture of your system...

regards,
Cindy

Kurt wrote:

> I got the different schemas part, but how would I set up John Smith to
> login?
>
> C. Ferguson <c_ferguson_at_rationalconcepts.com> wrote in message
> news:37D09090.A95B15CC_at_rationalconcepts.com...
> > different schemas for each company...and if you are not thinking along
> those
> > lines, why would you allow other companies to see/manipulate another
> companies
> > data?
> >
> > regards,
> > Cindy
> >
> > Kurt wrote:
> >
> > > Here's the scenario for Oracle 8i and/or WebDB on an NT4 server:
> > >
> > > 10 different companies say that want to use the database to store their
> > > sales. No other company should be able to access it.
> > >
> > > Each company wants one person to act as a MANAGER. MANAGERs have access
> to
> > > the sales of those whom report to them. The MANAGERs should also be
> able to
> > > add SALESMAN as their respective companies grow.
> > >
> > > Each SALESMAN should only see his own sales.
> > >
> > > 3 of the companies have a SALESMAN named "John Smith".
> > >
> > > Any recommendations/comments for setting up logins/security? How about
> the
> > > scenario itself? How do I keep John Smith from Company A separate from
> John
> > > Smith of Company B (apparently he's a boogie woogie bugle boy salesman).
> Am
> > > I making a mountain out of a mole hill? All the documentation I find
> seems
> > > to rely on the fact that it's only ONE company.
> >
> >
Received on Sat Sep 04 1999 - 15:45:35 CDT