Re: 1 user for multiple DB instances?

In article <Xsls4.9723$a27.201957_at_news1.rdc1.mb.home.com>,   "Brian W. Chester" <bwchester_at_home.com> wrote:
> Otis,
>
> You have to create a user on each and every instance!

Thanks Brian!
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?

Thanks,

Otis

> "Otis Gospodnetic" <otis_at_my-deja.com> wrote in message
> news:88se4e$p56$1_at_nnrp1.deja.com...
> > Hi,
> >
> > I created an Oracle user, and it works fine if I try connecting to
one
> > of my database instances, like this for example:
> >
> > prompt> sqlplus user/pass_at_mydb.domain.com
> >
> > However, if I try connecting to the a different DB, it fails, like
this:
> >
> > prompt> sqlplus user/pass_at_devdb.domain.com
> >
> > ERROR:
> > ORA-01017: invalid username/password; logon denied
> >
> > I can tnsping both mydb.domain.com and devdb.neomeo.com.
> >
> > Is there any way I can use the same username/password to connect to
> > different databases?
> > I'm not even sure how I 'tied' this user to the first DB instance
> > (mydb.domain.com). I don't remember doing anything other than this:
> >
> > connect internal
> >
> > CREATE USER user IDENTIFIED BY password
> > DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp
> > QUOTA UNLIMITED ON users
> > QUOTA 0 ON SYSTEM;
> >
> > GRANT CONNECT, RESOURCE TO user;
> >
> >
> > Thanks,
> >
> > Otis
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Feb 24 2000 - 12:50:08 CST