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

From: Syltrem <syltrem_at_videotron.ca>
Date: Wed, 30 Aug 2000 14:31:50 -0400
Message-ID: <nlcr5.1115$V91.60920@weber.videotron.net>

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 - 13:31:50 CDT