Information
Sybase ASE supports setting role passwords to ensure that all users have to enter a
password before using a protected role. Powerful roles such sa_role and sso_role should
be password protected to provide as an additional layer of security.
Rationale:
Password protecting powerful roles means that even if a user is granted that role (which
might have been granted through error or indirectly via the WITH GRANT option) they must
know the password to use it.
NOTE: Nessus has provided the target output to assist in reviewing the benchmark to ensure target compliance.
Solution
1. Connect to the ASE server with a user that has the sa_role and execute the
following SQL statement (where <Role> should be substituted for the role that is to
be password protected and <Password> for the new password):
set role '<Role>' with password '<Password>'