Re: Update the password field in table SYS.USER$
Date: 1996/06/21
Message-ID: <4qev38$fnn_at_lserv1.paging.mot.com>#1/1
Bo,
The easiest way to achive what you want is to use the undocumented Oracle sql feature of setting passwords by using the clause 'identified by values' for example if for user1, you set the password in one instance to test the password will be encrypted and stored, then you can use that string to set the passwords on other instances using
alter user user1 identified by value '<string> ;
NOTE NOTE: if you want to reset the passwords back to the original value, spool the
current value prior to using the above, and set it back using another
alter.
This can be automated using a stored procedure using dbms_sql, with
private db_links to all servers. If using this, name the db_links as the
sid of the server, which should also match the entry in 'tnsnames.ora'
for the instances entry. Let me know if you want to try this.
Another advantage of using stored procedues that it can establish a
session for you with the user name , and still alter the user back to
their passwords, so it does not impact their access.
I use this once a week to run special processing for some specific schemas, and
enables me to do so without knowing the actual schema users passwords.
Hope this helps,
--
Vikram Goel
Sr. Oracle DBA - Consultant
Aerotek Inc. My email: vgoel_at_emi.net
Motorola Info: Motorola email: vgoel_at_pts.mot.com
Mail Stop 39, Room S1014
1500 Gateway Blvd,
Boynton Beach, FL 33426
In article <31C9BC88.CBD_at_hsc.utah.edu>, Bo Lu <bo.lu_at_hsc.utah.edu> writes:
>I need to synchronize the user passwords between Oralce servers.
>I wonder if I can directly update the password field in the
>SYS.USER$ table. Has anybody had this experience?
>Thanks in advance!
>--
>Bo Lu
>Senior Programmer/Analyst
>Hospital and Clinical Informatics, U. of Utah
>801-581-5964, bo.lu_at_hsc.utah.edu
Received on Fri Jun 21 1996 - 00:00:00 CEST