update user's password

you can't update the expiry_date directly.


you'll have to change the user's password or change the profile of the user

How to change the user's password or change the profile of the user?

thanks

What about changing the password to what it already is?

select password from dba_users where username = '<user>';
alter user <user> identified by values '<pass>';

Use the encrypted password returned by the first quey in the second statement to set the password.

I cannot test this on my system because we have a password validation function that requres the passwords be different.

can I just use

alter user abc password expire;
the thing is there is a user profile which is assigned to users and one of the user's password is expired
how to update that?

Johnsone thnaks a lot but will this set up a new expiry date for a user's password?

My guess is that it should.  I cannot confirm that because we have a password validation function in place that does not allow that statement because you are changing the password to the same thing it currently is.

Try it.  There is no down side.  The worst that can happen is you change the password to what it is already set to.

Thanks for the confirmation.  I couldn't test it without changing the profile, which would reset the expire date and nullify the test.

So if a useer abc is unable to login because the passwd is expired.
To enable the password we will

reset the password like

  alter user abc password expire;

  and now when the next time user try to log in he would be asked to enter the new password.  is that right? would his pssword expire after 90 days?.

  or copy the original password and then change the password to new and then change it back to the original like

  select password,account_status from dba_users
where   username = 'abc';
 copy the password and save it

alter user abc identified by 'new_passwprd';

alter user abc identified by 'original_password';

thanks

I really appreciate to both of you.
You guys are excellent.

glad we could help