Re: Update the password field in table SYS.USER$

On Thu, 20 Jun 1996 15:03:04 -0600, Bo Lu <bo.lu_at_hsc.utah.edu> wrote:

>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

NO, don't do that.

Do this:

set heading off
set feedback off
spool passwords.sql
select 'alter user ' || username || ' identified by values ''' ||

        password || ''';'
from sys.dba_users
/
spool off

It will generate output like:

alter user TKYTE identified by values '698F1E51F530CA57'; alter user BOB identified by values '176E8F2194C5E9FA';

NOTE: maintain the ''' in the above, it is not a typo.

You can run the above on other databases to propagate the changes.

(above info gleened from an export file when trying to figure out how export can save the passwords. This syntax is not documented (the by values part))

Thomas Kyte
Oracle Government
tkyte_at_us.oracle.com                          

http://govt.us.oracle.com -- Check out our web site! Brand new, uses Oracle Web Server and Database

statements and opinions are mine and do not necessarily reflect the opinions of Oracle Corporation Received on Fri Jun 21 1996 - 00:00:00 CEST