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

> >> > 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.
>
> you have to program to accept the error and deal with - thats what sqlplus
> does and seemingly delphi doesnt.

But -- I should call an OCI function to actually change it, without an existing session, right?

-- 
With regards,

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