1.10 Use login triggers to validate users IP addresses - exec sp_logintrigger

Information

Sybase ASE supports login triggers; these execute a specified stored procedure every time a
user logs in. Login triggers can be used to carry out additional verification steps such as
checking the IP address that the user is logging in from is as expected.

Note: Global login triggers are available on ASE 15.0.2 and greater.

Rationale:

Login triggers can provide an additional layer of security through verification of criterion
such as IP address. Note that the IP address may be subject to spoofing or may indicate a
compromised client and as such should not be exclusively relied upon.

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 sso_role and execute the
following SQL statement where <Login_Name> should be substituted for the
username on which the login trigger will fire and <Sproc_Name> for the specific
stored procedure. If <Login_Name> is set to NULL, a global login trigger is registered
(i.e. for all users). Global login triggers can also be set via the sp_logintrigger
stored procedure.

exec sp_modifylogin <Login_Name>, 'login script', <Sproc_Name>

Note that the stored procedure registered as a login trigger must be available in the users
default database since Sybase ASE searches the sysobjects table in the users default
database in order to find the login trigger object.

See Also

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