1 user for multiple DB instances?

From: Otis Gospodnetic <otis_at_my-deja.com>
Date: Mon, 21 Feb 2000 22:27:32 GMT
Message-ID: <88se4e$p56$1@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 - 16:27:32 CST