Environment: Delphi 7, DOA 4.1
We are having a problem when user's password enter the expiration grace period and they are prompted for a new password. All user accounts are assigned a profile that has a password verification function. The password must have, at a minimum, 2 Upper, 2 Lower, 2 Numbers, and 2 Special Characters. The only Special Characters allowed are the # (pound sign) and the _ (underscore). This function works correctly when a user's password is modified directly from oracle (SQL*Plus). When the password is changed via our application it doesn't cause the verify password function to run and users change their password to something that includes non-valid special characters (an @ for example). When they then try to login using the new password it won't let them. We need to either turn off the automatic pop-up of the change password dialog or intercept the OK button click on the dialog to make sure they only are using a # or _ as their special character.
In our application we have a TOracleSession (orclsnMXT) and a TOracleLogon (orclLogon) components (in a datamodule). During the application startup we call a procedure that initiates the login process. Our code is as follows ( abbreviated):
dtmdlMXTMain.orclsnMXT.LogonDatabase := DefaultDB;
dtmdlMXTMain.orclLogon.Options := dtmdlMXTMain.orclLogon.Options -[ldDataBaseList] - [ldDataBase];
We then loop through the ParamStr and set the LogonDatabase, LogonUsername, and LogonPassword and change the orclLogin.Options to add back the ldDataBaseList (if needed) if there were any values in the ParamStr. Once that is done we then run the following:
if dtmdlMXTMain.orclLogon.Execute then
blnLoggedIn := True
It is during the execute of the orclLogon that the Change Password dialog appears and then changes the password. I cannot find a property setting to disable this action nor can I figure out where I can intercept the new password to make sure it meets our criteria. Can you help me with this problem.
Thanks
Richard Anderson
