Re: How to copy user passwds to different database ?

IMPORT in FULL mode will copy the users but you may not want to copy the whole database. Read the encrypted passwords in DBA_USERS, then you can recreate them by using

CREATE USER xxxxx IDENTIFIED BY VALUES 'password' ;

Where "password" is the encrypted string.

Sylvain Leclerc, DBA
sleclerc_at_magrit.com

-----Original Message-----
From: chlo_at_home.com (chlo) [mailto:chlo_at_home.com] Posted At: Monday, July 24, 2000 2:09 AM Posted To: server
Conversation: How to copy user passwds to different database ? Subject: How to copy user passwds to different database ?

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 Mon Jul 24 2000 - 00:00:00 CDT