Gary Kjos
garykjos at gmail.com
Thu Oct 21 10:52:32 CDT 2004
I have been using the Microsoft ODBC for Oracle Driver version 2 build 2.573.6200.00 for a few years to access Oracle 8 and 9 databases on a read only basis. All was well until the Oracle DBA's decided - or were forced to due to Sarbaine/Oxley legislation - make the passwords expire on a periodic basis on the Oracle user account that is used for the ODBC connection. The ODBC driver I am currently using doesn't seem to have the ability to allow the password to be changed, it just fires an error message window when the expired password is encountered. ODBC-call failed. Error ORA-28001: the password has expired The users could access the acount through SQL+ or another Oracle terminal tool like SQL Navigator or TOAD but that would be considered another security risk, so they don't want to provide any of those tools to the users. They want the users themselves to be able to change the passwords so that only they will know what the password is for their account. Anybody run into this or have any ideas? -- Gary Kjos garykjos at gmail.com