Re: HOW TO? 2 or more users using the same schema?

That's not a bad idea, but users will be able to access some applications through the web, the OSUSER would be something like SYSTEM or WEBUSER.

but thanks anyway

Patrick

Syltrem wrote in message ...
>The v$session view reports the Oracle user name (USERNAME) but also the o/s
>username (OSUSER). If you only want to know who is connected, then use this
>OSUSER field.
>
>If that can help...
>
>Syltrem
>
>"Patrick Joyal" <please.reply_at_to.the.newsgroup> wrote in message
>news:39ac246a_at_news...
>> Hi,
>>
>> is there a quick way to have 2 or more users using the same schema,
 without
>> having to grant privileges on every object and creating synonyms for
 every
>> objects?
>>
>> I could use the same account for each user, but I want to keep a trace
 for
>> each
>> user.
>>
>> In other words, I want one schema, and many user using that schema like
 if
>> it was their own
>> schema.
>>
>>
>> thanks for your help
>>
>> Patrick
>>
>>
>>
>
>
Received on Wed Aug 30 2000 - 14:31:19 CDT