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.
Controls
-
ASE, SYC SAP Adaptive
Server Enterprise -
O90 Oracle9i
-
O10 Oracle 10g
-
ORA Oracle 11g
Syntax
|
1 |
PWDialog=<span>value</span> |
|
Parameter |
Description |
|---|---|
|
value |
Specifies whether the Password Expired
|
Default
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
profileAlthough 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.DbParameter="PWDialog=1"