Sets and displays the global login trigger. This global login trigger has the same characteristics as a personal login script. It is executed before any personal login script for every user that tries to log in, including system administrators and security officers.
sp_logintrigger 'global login trigger name'
If you include no parameter, sp_logintrigger displays the current login trigger status and name if it exists, and no rows if there is no global login trigger defined.
sp_logintrigger 'master.dbo.myproc'
1> sp_logintrigger 2> go Global login trigger Status ---------------------------------- ------- sybsystemprocs.dbo.myproc Enabled (1 row affected) (return status = 0
1> sp_logintrigger 2> go Global login trigger Status -------------------- ------ (0 rows affected)
sp_logintrigger 'drop'
To find out if a global login trigger is defined and enabled, use the @@logintrigger global variable.
There is a difference between this global login and the private login script. This global login trigger is stored by name in sysattributes, while the private login script is stored only by object ID.
The permission checks for sp_logintrigger differ based on your granular permissions settings.
Setting | Description |
---|---|
Enabled | With granular permissions enabled, you must be a user with manage security configuration privilege to set a new login trigger. Any user can execute sp_logintrigger to display the current global login trigger. |
Disabled | With granular permissions disabled, you must be a user with sso_role to set a new login trigger. Any user can execute sp_logintrigger to display the current global login trigger. |