Default language.

Restriction qualifications scenarios


If the Disable Default Character Restrictions check box is not selected, the qualifier entered in the Restrictions Qualifier field is appended to the current default restriction. However, you cannot change the qualifier already defined in the default qualifier, which enforces that the password must include at least one lowercase, one uppercase letter, and a special character.


Scenario 1


To add a restriction requiring users to include a numeric character in their password, enter the following qualification in the Restriction Qualifier field:

'New Password' LIKE "%[0-9]%"

This qualifier is appended to the default qualifier. With this restriction, aA1# is acceptable passwords if the minimum length for password is 4.


Scenario 2

The following qualification would not work because you cannot invalidate the default qualifier, which requires a letter in the password.

('New Password' LIKE "%[^A-Z]%") AND ('New Password' LIKE "%[^a-z]%"

If the Disable Default Character Restrictions check box is selected, the default qualifier is ignored. The qualifier entered in the Restrictions Qualifier field is the only qualifier used.


Scenario 3

To force users to include numeric characters in their password, enter the following qualification in the Restrictions Qualifier field:

'New Password' LIKE "%[0-9]%"

With this restriction, 1111 is an acceptable password if the minimum length is 4. A password without any numbers, like aaaa, would cause an error.

Scenario 4

To force users to include special characters in their password, enter the following qualification in the Restrictions Qualifier field:

'New Password' LIKE "%[\`\~\!\@\#\$\%\^\&\*\(\)\-\_\=\+\{\}\[\]\\\|\;\:\'\"\,\<\.\>\/\?]%"

With this restriction, a password such as r3m%dst4 would be accepted, but a password such as 7aord7y5 would not be accepted. The backslash (\) is the escape character which stops the query when any character is found to be true. Modify this qualification if you want users to exclude any special characters rom the password. 

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*