Some information in this section is from the article "Login Triggers in ASE 12.5". Copyright 1998–2002,
Rob Verschoor/ Sypron B.V.
Login triggers execute a specified stored procedure every time a user logs in. The login trigger is an ordinary stored procedure, except it executes in the background. It is the last step in a successful login process, and sets the application context for the user logging in.
Only the system security officer can register a login trigger to users in the server.
To provide a secure environment, the system administrator must:
Revoke select privilege on the set_appcontext function. The owner of a login trigger must have explicit permission to use set_appcontext, even if the owner has sa_role.
Configure a login trigger from a stored procedure for each user, and register the login trigger to the user.
Provide execute privilege to the login trigger that the user executes.
