Re: 1 user for multiple DB instances?

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.
Received on Sat Feb 26 2000 - 03:27:18 CST