Database Security Products (MOSC)

MOSC Banner

create user with same password as another user

edited Jan 15, 2013 4:11AM in Database Security Products (MOSC) 8 commentsAnswered
 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 :

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center