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

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 Fri Sep 03 1999 - 22:22:56 CDT