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?

Depends on whether there is a grace period.

For example:
ALTER PROFILE developer LIMIT password_grace_time 10;

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)