Drop Login Trigger

From DBArtisan
Jump to: navigation, search

Go Up to Available object actions by DBMS

The Drop Login Trigger action lets you build and submit an sp_modifylogin or ALTER LOGIN call that specifies a NULL login script option. This removes the configured login trigger for the login, the default database stored procedure that executes each time the user successfully logs in.

Note: If a login has a login trigger configured, the specified stored procedure name is visible in the Login editor. For details, see Logins Editor (Sybase ASE).

Platform Availability

To Remove the Currently Configured Login Trigger for a Login

1. On the DBArtisan Datasource Navigator/Explorer, expand the data source nodes until the Logins node is visible and then select the Logins node.
2. Right-click a login and select Login Trigger Actions > Drop Login Trigger from the context menu. The Drop 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

Displays the login you selected to run the action against.


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. For more information, see Preview.