23.9.1 Setting a new limit on the number of consecutive certification failures

Use CREATE CONNECTION SECURITY to set limits on the number of consecutive certification failures. Examples follow:

Example 1
Set limits on the number for consecutive certification failures as follows:
  • Permitted number of consecutive certification failures: 3
  • Account lock period: 30 minutes

CREATE CONNECTION SECURITY
   FOR CONNECT PERMISSION COUNT 3     ...1
               LOCK 30 MINUTE         ...2

Explanation
  1. Specifies the permitted number of consecutive certification failures.
  2. Specifies an account lock period.
Example 2
Set limits on the number of consecutive certification failures as follows:
  • Permitted number of consecutive certification failures: 5
  • Account lock period: Permanent

CREATE CONNECTION SECURITY
   FOR CONNECT PERMISSION COUNT 5     ...1
               LOCK UNLIMITED         ...2

Explanation
  1. Specifies the permitted number of consecutive certification failures.
  2. Specifies an account lock period.