Re: So many instances..so many user accounts...too many passwords!

>In article <45et26$skr_at_earth.njcc.com> Joanne Corcodilos writes:
>I'm wondering how other Oracle sites are handling multiple instances
>which have multiple user accounts. How do you handle the same user
>needing access to two or more servers?
>
>We're faced with the problem of having users who need access to multiple
>Oracle instances. We'd rather not have the user need to memorize
>additional passwords. How are other sites handling this situation?
>Any ideas on synching passwords?

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

If you are on a UNIX platform, and if you are running the multiple instances on the same machine, you can use the operating system password for user validation. When you create a user, you could use

create user <username> identified externally by <password> etc

The 'externally' clause uses the operating system password file for login validation. This is what I did at a previous workplace. If you want to use external validation on multiple servers, maybe you should consider NIS.

Hope this helps.

Nalini

Nalini Vallampati
UNIX Admin/Oracle DBA
AT&T Capital - GIS
Miamisburg, OH 45342 Received on Fri Oct 13 1995 - 00:00:00 CET