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

Martijn Tonies wrote:
>>>>>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?

That's one solution. The other is to pass through the same SQL that you just looked at.

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