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

I never figured that into the scenario. For the sake of arguement, I suppose setting up one account/schema then utilizing Views to access the information. Any thoughts on this?

            -=Kurt=-

C. Ferguson <c_ferguson_at_rationalconcepts.com> wrote in message news:37D184EF.A5255F8F_at_rationalconcepts.com...
> 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 Sun Sep 05 1999 - 00:08:08 CDT