PWDialog
database parameter
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
|
1 |
PWDialog=value |
|
Parameter |
Description |
|---|---|
|
value |
Specifies whether the Password Expired dialog box
|
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:
1SQLCA.DBParm="PWDialog=1"