Never mind, I just found the workaround. It just involves creating a procedure owned by system to do the actual password change. I should have thought of that :( <embarassed mumbling> Jay Miller -----Original Message----- Sent: Thursday, August 09, 2001 4:16 PM To: '[EMAIL PROTECTED]' IDENTIFIED BY 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
