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

A copy of this was sent to "Kurt" <rkdata_at_uswest.net> (if that email address didn't require changing) On Sat, 4 Sep 1999 11:04:49 -0500, you wrote:

>I got the different schemas part, but how would I set up John Smith to
>login?
>

You might also consider using fine grained access control. You can read about that at http://govt.us.oracle.com/~tkyte/index.html

Each John Smith would need their own UNIQUE login of course in any solution you come up with (jsmith1 and jsmith2 for example)

>
>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.
>>
>>
>

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Sat Sep 04 1999 - 12:39:52 CDT