session level trigger?

• Daniela-267581

  Ten Centuries

  Points: 1119

  More actions

  May 24, 2006 at 1:24 am

  #113133

  Hi,

  Is any possibility to create a session level trigger where run every time an instance of sql server is open. I am trying to read there what user is connected and only to some of them to allo to view my database

  ---

  Daniela

• Yelena Varshal

  SSC-Dedicated

  Points: 34286

  More actions

  May 24, 2006 at 10:49 am

  #639859

  Daniela,

  You would like to use SQL Server Profiler and create a Trace for the Security Audit events: Audit Login, Audit Logout and Audit Login Failed.

  Regards,Yelena Varsha