MIN_PASSWORD_LENGTH Option

Sets the minimum length for new passwords in the database.

Allowed Values

Integer greater than or equal to zero

The value is in bytes. For single-byte character sets, this is the same as the number of characters.

Default

0 characters

Scope

Can be set for the PUBLIC group. Takes effect immediately. Requires DBA permissions to set this option.

Description

This option allows the DBA to impose a minimum length on all new passwords for greater security. Existing passwords are not affected.

Example

Set the minimum length for new passwords to 6 bytes:

SET OPTION PUBLIC.MIN_PASSWORD_LENGTH = 6