Page History: Database Trigger Sample - SQL Server

Compare Page Revisions

0 Current 0

« Older Revision - Back to Page History - Current Revision

Page Revision: Mon, Dec 02, 2013, 4:03 PM

The following database trigger will allow the MyUser user to login only from the MyWebServer machine.

if exists (select 2 from sys.server_triggers where name = N'logon_test_trigger')
    drop trigger logon_test_trigger on all server
go
create TRIGGER logon_test_trigger
ON ALL SERVER WITH EXECUTE AS 'sa' FOR LOGON AS
BEGIN

    /* Within a logon trigger, ROLLBACK will cancel/disable the logon */

    IF ORIGINAL_LOGIN() = 'MyUser' 
    AND UPPER(HOST_NAME()) <> 'MyWebServer'

        ROLLBACK; 

END