create user with same password as another user
Hello,
In Oracle 11gR1 and above, is there a way to create (or alter) a user so that his password is the same as a different Oracle user? Of course, I do not know what the source user's password is in the first place.
I tried this :
-- Source user
CREATE USER A IDENTIFIED BY A;
grant create session to A;
SELECT DBMS_METADATA.GET_DDL('USER', USERNAME)
FROM DBA_USERS
where username='A';
Generates :
CREATE USER "A" IDENTIFIED BY VALUES 'S:3E1AC85AAE88AEFA85AF20071E74242DB1BC8DC57E890C19FC48128049D6;AFCC9478DFBF9029' ...
Which I change to :
0