Database Administration (MOSC)

MOSC Banner

Capture passwords

edited Jan 24, 2012 11:23PM in Database Administration (MOSC) 3 comments
 Hello,
I recently found a way how to capture the old password/new password (in clear text) whenever an existing user changes his password or new user is created. The steps are listed below

sqlplus / as sysdba
sql> @?/rdbms/admin/utlpwdmg.sql
sql> create table tbl_pswrds (db_user varchar2(30), old_pass varchar2(30), new_pass varchar2(30));
-- add the following command in the body of the "verify_function" function.
      insert into tbl_pswrds (db_user,old_pass, new_pass) values(username,old_password,password);
Now, each time an existing user changes his password or a new user is created, the old password and new password are recorded in tbl_pswrds.

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