Store earlier Password

  • Hello

    I need to reset password for one of the logins since somehow it was lost. But we are not sure if it will give problem elsewhere. Is there a way to 'store' the ealier password somewhere. We donot remember the earlier password. What commands would be the ones to use? For oracle we have

    select username, password from dba_users where ; (say) Query1

    alter user username identified by new_password_here;

    To put back the old pw:

    alter user username identified by values 'password value from Query 1 above' ;

  • Do you mean store the current password?

    Search sp_help_revlogin and this will script out the logins and hash of the current password.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply