Re: How to copy user passwds to different database ?

Run this script in sqlplus using "old" database: -- script starts here
set pagesize 0 -- make sure you get no column headings set feedback off -- and no #rows message col cmd form a80
spool make_pw.sql
select 'alter user '||username||' identified by values '''||password||''';' cmd from dba_users where username not like 'SY%';

spool off
-- script ends here

Then log into the "new" database and run make_pw.sql

chlo wrote:

> Hi all,
>
> Can anybody tell me how could I copy all the oracle user passwords ? ie. Can I
> export all the user ids and passwords out and import it back to another
> database ?
>
> Thanks..
Received on Thu Jul 27 2000 - 00:00:00 CDT