Oracle password change using the Verify Password function

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • neuge@lconn.com

    Oracle password change using the Verify Password function

    I am trying to write a Change password process to
    change user password on an Oracle 8i database with a
    Powerbuilder client. When the PL/SQL function supplied
    by Oracle (Verify Password) is enabled for the profile
    the Alter User username identified by newpassword fails
    with a ORA-20003 Verify password has failed.

    The function works perfectly from a SQL editor such as
    Embarcadero's Rapid SQL.

    I found one report that suggests using the OCIPasswordchan ge()
    function but appears to be very involved.
Working...