PWDCredentials Example 2: The new password must be different from the old one

Previous Next

See Also

To specify that a new password must be different from the old one:

1. Authorize users to change their password. See "Authorizing Users to Change their Password".
2. Specify that the PWDCREDENTIALS table component is to handle the password management. See "Installing and Using the PWDCredentials Table Component"
3. Add a restrictive constraint in your application with the following SQL statement :

SELECT '' violated FROM PWDCREDENTIALS WHERE OLDPASSWORD = NEWPASSWORD