Version: 12.0.0-rc-23-10
Build #: 29782
Build Date: 2012-Oct-17 11:35:01 AM

Incorrect Syntax for Alter Server Roles in Sybase ASE

1. Navigate to Sybase Adaptive Server Enterprise/15.0.2 and go to Security--> Server Roles

2. Alter a Server Role - change both Min Password Length or Max Failed Logins

3. You can see that incorrect syntax is generated for the Alter.

USE master
GO
ALTER ROLE FLT_66
    SET ,
    MIN PASSWD LENGTH 3,

,
    MAX FAILED_LOGINS 4

4. If you change one of the parameter either Min Password Length or Max Failed Logins, it creates incorrect syntax

See attached pics