Re: 1 user for multiple DB instances?

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 - 02:09:53 CST