Re: Transferring usernames and password from a database to another

Sure,
use the following code
--
set pagesize 0 feedback off heading off spool temp.sql
select 'create user '||username||' identified by password||chr(10)||

           'alter user '||username||' identified by values '''|password||''''
from dba_users;

spool off
disconnect
connect sys/<password>@other_database
start temp.sql
exit
--
now connect to the other database, run temp.sql and that should be it.
Of course you'll still need to copy the privileges.

Hth,

Sybrand Bakker, Oracle DBA

Lucie Dore <lucie.dore_at_space.gc.ca> wrote in message news:37779730.8D814C57_at_space.gc.ca...
> Hi,
> I just created a new database ans I would like to transfer the
> usernames and password created in another database to this new one. This
> to preserve the actual passwords of the users. Is it possible? Anybody
> knows how to do this?
> Thanks
>
Received on Mon Jun 28 1999 - 12:03:19 CDT