Change password pl/sql?

Hi,

I'm looking for a pl/sql procedure/function that changes user's password if the given old_password matches user's current password in Oracle.

Something like:

function change_passwd(

p_username in string, -- => username to change password for
p_old_passwd in string, -- => user's current password
p_new_password in string) -- => user's new password
return integer  -- return 0 for succesful operation, 


                           --return 1=> incorrect old_password 

                           --return 2 => p_username doesn't exist 

                           --return 3 => bad p_new_password 

I know the encrypted password for all users is stored in sys.dba_users table's password column but I don't know how to encrypt p_new_password to match the encrypted password.

Any help is greatly appreciated.

Regards,

Kirmo Uusitalo Received on Wed Nov 12 2003 - 07:12:42 CST