Add/Modify Login Trigger
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 Rapid SQL, expand the Logins node. Rapid SQL displays all logins for the datasource.
- 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. | |
|
Dependencies |
Review the referring and referred objects that will be automatically resolved when you execute this operation. For details, see Dependencies. | |
|
Preview |
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