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.

3 characters

Option can be set at the database (PUBLIC) level only.

Requires the SET ANY SECURITY OPTION system privilege to set this option. Takes effect immediately.

This option imposes a minimum length on all new passwords for greater security. Existing passwords are not affected.

Set the minimum length for new passwords to 6 bytes:

SET OPTION PUBLIC.MIN_PASSWORD_LENGTH = 6