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

On Wed, 15 Jun 2005 14:00:12 +0200, "Martijn Tonies" <m.tonies_at_upscene-removethis.nospam.com> 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?

 At the OCI level, OCIPasswordChange can be used to change the password after it's expired.

http://oraclesvca2.oracle.com/docs/cd/B14117_01/appdev.101/b10779/oci16ms9.htm#573855

 So any tool using this function will be able to offer that functionality.

 I don't recall seeing an interface to this through SQL*Plus, though.

-- 
Andy Hassall / <andy@andyh.co.uk> / <http://www.andyh.co.uk>
<http://www.andyhsoftware.co.uk/space> Space: disk usage analysis tool