From JayMiller@TDWaterhouse.com Thu, 09 Aug 2001 13:59:16 -0700 From: "Miller, Jay" Date: Thu, 09 Aug 2001 13:59:16 -0700 Subject: Password_verify_function in 8.1.6 doesn't allow ALTER USER IDENTI Message-ID: MIME-Version: 1.0 Content-Type: text/plain I found plenty of angry people with my problem on Metalink forums, but no one that got an answer from Oracle. We still have a number of people connecting to Oracle via Powerbuilder applications. We want to use a password_verify_function but we'll be upgrading 8.1.6 soon, and the ALTER USER xxx IDENTIFIED BY xxx; command will no longer work in conjunction with it (I just discovered this today during testing in development). The Powerbuilder code to change the password currently uses ALTER USER.... Does anyone know if 1) There is any way to get it to work short of granting ALTER USER (*not* an option :) to each user 2) OCIPasswordChange() can be called from Powerbuilder, and where I could find sample code to do so if it is possible 3) There is any other solution? TIA, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: JayMiller@TDWaterhouse.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).