1.9 Set passwords on important roles

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>'

See Also

https://workbench.cisecurity.org/files/1612