Add/Modify Login Trigger

From DBArtisan
Jump to: navigation, search

Go Up to Available object actions by DBMS

This action lets you build and submit an sp_modifylogin or ALTER LOGIN call that specifies a login script option. The target login trigger can be any stored procedure located on the user’s default database, and the procedure will run each time the user successfully logs in. The action can be used to:

  • Add a login trigger to a login that currently has no login trigger configured
  • Change the specified stored procedure for a login that already has a login trigger configured

Platform Availability

To Specify the Stored Procedure Used as a Login Trigger for a Login:

1. If using DBArtisan, on the Datasource Navigator/Explorer, expand the data source nodes until the Logins node is visible and then select the Logins node. DBArtisan displays the logins.
2. Right-click a login and select Login Trigger Actions > Add/Modify Login Trigger from the context menu. The Add/Modify Login Trigger dialog opens.
3. Use the following table as a guide to understanding and modifying settings in the wizard:
Step Settings and tasks

Action options

From the Login Procedure dropdown, choose the default database stored procedure that is to be configured as the login trigger for this login.


Review the referring and referred objects that will be automatically resolved when you execute this operation. For details, see Dependencies.


Preview the DDL generated for the operation and when ready, click Execute.

After executing this action, the specified stored procedure name is available in the Login editor. For details, see Logins Editor (Sybase ASE).

Related Information