Sets the minimum length for new passwords in the database.
The value is in bytes. For single-byte character sets, this value is the same as the number of characters.
|PUBLIC role||For current user||For other users|
|Allowed to set permanently?||Yes, with SET ANY SECURITY OPTION||No||No|
|Allowed to set temporarily?||Yes, with SET ANY SECURITY OPTION||No||No|
This option allows the database administrator to impose a minimum length on all new passwords for greater security. Existing passwords are not affected. Passwords have a maximum length of 255 bytes and are case sensitive.
Set the minimum length for new passwords to 6 bytes.
SET OPTION PUBLIC.min_password_length = 6;