Re: Can a user which "password is expired" change its own password?

Martijn Tonies wrote:
> Hi,
>
> Obviously, the ALTER USER statement to change an expired password
> works from an existing connection.
>
> But can a user - with an expired password - change his/her password?
>

Obviously:
SQL> create user scott identified by scott password expire;

User created.

SQL> connect scott
Enter password:
ERROR:
ORA-28001: the password has expired

Changing password for scott
New password:

You owe me a cup of coffee

-- 
Regards,
Frank van Bortel