Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: 1 user for multiple DB instances?

Re: 1 user for multiple DB instances?

From: Gorm Larsen <gorm_larsen_at_vestjyde.dk>
Date: Thu, 24 Feb 2000 22:30:44 +0100
Message-ID: <MPG.131fc173eeacdb419896a5@valhal>


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.

--
Gorm Larsen Received on Thu Feb 24 2000 - 15:30:44 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US