Column password is readable only by a user with sso_role, this behavior is unchanged in Adaptive Server 15.0.2.
master..syssrvroles ( ... password varbinary(128) null, /* encrypted password */ ...)