1864378 - Error 9551: "password does not have any numeric characters" returned by sp_password - SAP ASE

• sp_password to change a user password to a string without a numeric character included fails with the messages 9551 and 17720:

sp_password 'my_current_password#1' , 'my_new_password_no_digit' , 'username'
go

Msg 9551, Level 16, State 1:
Server 'SYBASE', Procedure 'sp_password', Line 118:
The specified password does not have any numeric characters. New passwords must have at least one numeric character.

Msg 17720, Level 16, State 1:
Server 'SYBASE', Procedure 'sp_password', Line 128:
Error:  Unable to set the Password.
(return status = 1)

• sp_passwordpolicy  'clear' , 'min digits in password' was previously executed to clear the requirement that the password include 1 or more digits.

• SAP Adaptive Server Enterprise (ASE) 15.7
• SAP Adaptive Server Enterprise (ASE) 16.x
• Sybase Adaptive Server Enterprise (ASE) 15.5
• Sybase Adaptive Server Enterprise (ASE) 15.0

integer, security, enforcement, enforce, password, digits, minimum, policy  , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem