To change the limit on the number of consecutive certification failures, first use DROP CONNECTION SECURITY to cancel the existing limit, and then use CREATE CONNECTION SECURITY to set a new limit. An example follows.

Example

Change the limit on the number of consecutive certification failures as follows:

• Permitted number of consecutive certification failures: 5
• Account lock period: 10 hours

 
DROP CONNECTION SECURITY
    FOR CONNECT                        ...1
CREATE CONNECTION SECURITY
    FOR CONNECT PERMISSION COUNT 5     ...2
                LOCK 10 HOUR           ...3
 

Explanation

1. Cancels the existing limit on the number of consecutive certification failures.
2. Specifies a new permitted number of consecutive certification failures.
3. Specifies an account lock period.