Some of the information in this section is from the
article “Login Triggers in ASE 12.5”. Copyright
1998–2002, Rob Verschoor/ Sypron B.V.,http://www.sypron.nl/logtrig.html
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, System Administrator, or database administrator can register a login trigger to other users in the server, although a user can register his or her own login.
To provide a secure environment, the database 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.
