Answer:

As far as Ican remember the syntax is:

alter user <user> identified by values 'encrypted_string';

h.t.h.

BJ...

Question:

>Hello,
>
>Last night as I was working on a customer database, I tried to reset a
>user's password back to what it had been before I changed it.
>
>I've reset the encrypted string -- which then returns the plaintext
>password when the user tries to log in again -- dozens of times on
>databases from 7 to 8i with no problem, but I couldn't remember the
>syntax.
>
>I thought it was:
>
>alter user barth identified by 'encryptedstring'
>
>but I keep getting:
>
>ORA-00988: missing or invalid password(s)
>
>Unfortunately, I had not documented the syntax because I trusted
>myself to not forget. Oops! Thanks for all the help,
>
>Barth
>--
>Barth Siemens
>Change the email address from nospam to bsiemens.