Re: 1 user for multiple DB instances?

From: Otis Gospodnetic <otis_at_my-deja.com>
Date: Fri, 25 Feb 2000 05:27:39 GMT
Message-ID: <8953s7$1jd$1@nnrp1.deja.com>

In article <MPG.131fc173eeacdb419896a5_at_valhal>, Gorm Larsen <gorm_larsen_at_vestjyde.dk> wrote:
> In article <893ugu$4k0$1_at_nnrp1.deja.com>, otis_at_my-deja.com says...
> > In article <Xsls4.9723$a27.201957_at_news1.rdc1.mb.home.com>,
> > "Brian W. Chester" <bwchester_at_home.com> wrote:
>
> > Although I don't understand how when I do CREATE USER.... Oracle
knows
> > which instance this user is for....
> > How does it know that it needs to tie this user to instance A and
not B?
>
> > > > connect internal
> > > >
> > > > CREATE USER user IDENTIFIED BY password
>
> When you connect as internal, you will always connect to an instance
and
> the user you create will be tied to that instance.

But which instance?
The one from ORACLE_SID env. variable?

Thanks,

Otis

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Feb 24 2000 - 23:27:39 CST