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

"Martijn Tonies" <m.tonies_at_upscene-removethis.nospam.com> wrote in message news:11b0ulkmfh6qt0f_at_corp.supernews.com...
> 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
>
>

you have to program to accept the error and deal with - thats what sqlplus does and seemingly delphi doesnt. Received on Wed Jun 15 2005 - 14:34:25 CDT