Description
Controls whether a Password Expired dialog box displays in an application at runtime if a user's password has expired.
When PWDialog is set to 1, the Password Expired dialog box prompts users to change their passwords if they attempt to log in to the database with an expired password. By default, PWDialog is set to 0 to specify that the Password Expired dialog box does not display in your application at runtime.
The setting of PWDialog affects applications only at runtime. It has no effect in the development environment because, regardless of the PWDialog setting, the Change Password dialog box displays in the development environment to prompt users to change an expired password.
When to specify PWDialog
You must specify a value for PWDialog before connecting to the database.
Applies to
ASE, SYC SAP Adaptive Server Enterprise
O90 Oracle9i
O10 Oracle 10g
ORA Oracle (for 11g and later)
Syntax
PWDialog=value
|
Parameter |
Description |
|---|---|
|
value |
Specifies whether the Password Expired dialog box displays in an application at execution time to prompt the user to change an expired login password. Values are:
|
Default value
PWDialog=0
Usage
When to use
Setting PWDialog to 1 to display the Password Expired dialog box in your application provides a convenient way for you to notify your users that a password has expired and allow them to change it.
What happens
When the Password Expired dialog box displays in your application at runtime, it notifies users that the password for their login ID has expired and prompts them to supply a new password. For example, for Adaptive Server Enterprise, the sp_password system stored procedure runs to set the new password. Once the password has been changed, the database connection succeeds.
If the user clicks Cancel to close the Password Expired dialog box without changing the password, the database connection fails and a message displays indicating that the password has expired.
Examples
To display the Password Expired dialog box when needed in your application:
-
Database profile
Although the setting of PWDialog has no effect in the development environment, you might want to set it in your database profile to generate connection syntax on the Preview page that you can copy into your code. Select the Display Runtime Dialog When Password Expires check box (for ASE or SYC connections) or the Password Expiration Dialog check box (for Oracle connections) on the Connection page in the Database Profile Setup dialog box.
-
Application
Type the following in code:
SQLCA.DBParm="PWDialog=1"
