Re: Copying usernames/passwords from one instance to another

Yes it can be done!

1. Create all the users you created on your existing database.
2. Run the following script on the existing database:

             select 'ALTER USER &&1 IDENTIFIED BY VALUES '||''''||Password||''''||';'

               from DBA_USERS where Username = UPPER('&&1');

         Spool the output of this script. This will create a script you can run on your new database to set the

         passwords to what they were in the existing database.

Roy Klassen @pei.sympatico.ca

David Rohland <drohland_at_isc.upenn.edu> wrote in article <01bc9e91$40b23a80$c7495b82_at_drohland.umis.upenn.edu>...
> Has anyone successfully been able to create users in a new database by
> copying their usernames and original passwords from an existing database?
>
>
  Received on Sun Aug 03 1997 - 00:00:00 CDT