Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: 1 user for multiple DB instances?
Otis,
You have to create a user on each and every instance!
HTH Brian
"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.
Received on Mon Feb 21 2000 - 19:17:43 CST
![]() |
![]() |