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

Hello Frank,

> > 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

I'm using Delphi and ODAC to connect to Oracle - and it raises the ORA-28001 exception alright, but that's it...

No dialog or anything to change the password. I'll investigate a bit further.

-- 
With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com