Re: 1 user for multiple DB instances?

Genau. That is what I wondered. Thanks.

Otis

In article <951557437.19292.0.pluto.d4ee154e_at_news.demon.nl>,   "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:
> The SID that is set in the registry (NT) or your profile (Unix)
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> Otis Gospodnetic <otis_at_my-deja.com> wrote in message
> news:8981oe$30e$1_at_nnrp1.deja.com...
> > In article <MPG.13211a70fe1cfc1a9896a7_at_valhal>,
> > Gorm Larsen <gorm_larsen_at_vestjyde.dk> wrote:
> > > In article <8953s7$1jd$1_at_nnrp1.deja.com>, otis_at_my-deja.com says...
> > > > > 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?
> > >
> > > I know my english isn't perfect, but is it really that bad ?
> >
> > No, not at all :)
> > Yes, when you do connect username/password_at_SID-HERE then you connect
to
> > SID-HERE instance.
> > But which instance do you connect to when you say just connect
internal?
> >
> > Otis
> >
> > > [Teaching mode on]
> > >
> > > connect system/manager_at_sid_a
> > > create user x identified by x_psw;
> > > user x is tied to instance sid_a
> > >
> > > connect system/manager_at_sid_b
> > > create user x identified by x_psw;
> > > user x is tied to instance sid_b
> > >
> > > You will now have user x 2 times, so you can:
> > > conn x/x_psw_at_sid_a and
> > > conn x/x_psw_at_sid_b
> > >
> > > [Teaching mode off]
> > > :-)
> > >
> > > --
> > > Gorm Larsen
> > >
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Feb 26 2000 - 21:45:30 CST