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

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 - 21:22:29 CDT