Creating a Copy of a User Account

[rpetrk]

Is there a way to create a copy of a user account that will preserve the same password as original?

[davey23uk]

yes, pull the passwords out of dba_users and use that to create the new user with

[Thomasps]

SQL> conn / as sysdba
Connected.
SQL> select password from dba_users where username='THOMAS';

PASSWORD
------------------------------
063D8DE086C2860D

SQL> alter user xyz identified by values '063D8DE086C2860D';

User altered.

SQL> conn thomas/thomas
Connected.
SQL> conn xyz/thomas
ERROR:
ORA-01017: invalid username/password; logon denied


Warning: You are no longer connected to ORACLE.
SQL> conn / as sysdba
Connected.
SQL> select username,password from dba_users where username in ('THOMAS','XYZ');

USERNAME                       PASSWORD
------------------------------ ------------------------------
XYZ                            063D8DE086C2860D
THOMAS                         063D8DE086C2860D

Some thing fishy... Version: 10.1 Oracle on Windows 2000

[Thomasps]

Some thing new in 10g.

You can use the encripted password for the same user and not for a new user. That is you can never create user with same password, if you don't know the password. I mean, you can't use encrypted password for an existing user to create a new user! Read metalink doc: 279355.1

[davey23uk]

hmm perhaps not then, i thought that would work