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 - 11:04:49 CDT
