Re: Copying Username & Passwords from one instance to another?

Export the database schema only (rows=n option). If you are on unix, use grep on the exp file for "CREATE USER" and "ALTER USER" to extract those statements. Edit the extracted file and add semicolons at the end of each line. Then you can run the file on the new database from sql*plus. Note that the password is encrypted and created with different syntax than the normal create user command.

Good luck,
Steve

In article <4gd69t$qou_at_pulp.ucs.ualberta.ca>, you_at_somehost.somedomain says...
>
>Is there a way to copy a username and password from one instance to
>another and retain the same password? I need to migrate users from an
 old
>instance to a new one and I would like all users to retain their old
>passwords. Thanks in advance.
>
Received on Thu Feb 22 1996 - 00:00:00 CET