Re: login auditing

From: Dejan Sarka (dejan_please_reply_to_newsgroups.sarka_at_avtenta.si)
Date: 08/25/03 

Date: Mon, 25 Aug 2003 21:23:20 +0200

You can use Profiler, save the trace in the table and create an insert
trigger on that table. Consider using Windows possibilities - in 2000 and
2003 you can use account policies and limit users to login on certain hosts
only. 

-- 
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Nishu" <collect@yamunda.com> wrote in message
news:024e01c36b39$2ebe30b0$a401280a@phx.gbl...
> I want to restrict certain login to login from particular
> hosts and get an e-mail if the login is attempted from
> different host.  How can I do that? Is there something
> similar to "login triggers" functionality of Sybase where
> you can write a trigger that will be executed when login
> attempt is made.
>
> TIA,
>
> Nishu

Relevant Pages

  • Re: Logon triggers
    ... it's not that if you mess up the login trigger that no one can ... You can still connect on the DAC (Dedicated Administrator ... Connection) to drop the trigger. ... Event Notifications since in the future I want to log DDL & SQL Config ...
    (microsoft.public.sqlserver.security)
  • Re: Creating a Trigger on Access
    ... I don't think a 'SELECT' trigger would be a good idea since data could be ... access for reasons other than login. ... a stored procedure would be the ... DECLARE @ReturnCode int ...
    (microsoft.public.sqlserver.security)
  • Re: are triggers atomic?
    ... If I write a trigger for a file, ... fact that it will conclude before another login on say port ... Maybe I should have been using a readu lock in my ...
    (comp.databases.pick)
  • Re: Disable or prevent Trusted Connection (-E) logins [DDL triggers]
    ... You could create a login trigger like this one: ... CREATE TRIGGER LimitLogins ... DECLARE @TrustedConnection INT ... Be sure and test a login trigger very carefully, since a mistake can lock you out of the server. ...
    (microsoft.public.sqlserver.server)
  • Trigger**
    ... I've a following trigger which is fired in update status and make all ... destination table) ... ,but when I change the emp_status (by another login which has not access to ... table,an error occurred that you have no permission to update the second ...
    (microsoft.public.sqlserver.programming)