Re: Log of user activity
From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 10/27/03
- Previous message: Guillermo Casta?o A: "Log of user activity"
- In reply to: Guillermo Casta?o A: "Log of user activity"
- Next in thread: Hari: "Re: Log of user activity"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Mon, 27 Oct 2003 15:58:56 -0700
You can enable login auditing by from within Enterprise
Manager - select the server, select properties, go to the
security tab and select Success or All to monitor logins
(the service would need to be restarted after changes to
this).
However, this won't get you logouts or information for a
particular database. For that you would need to use a trace
(or Profiler) to capture the login, logout. The security
audit class has these events. In terms of the database, I
can't think of an access type of thing to monitor - only
thing I can think of is monitoring the t-sql, stored
procedures and the database id.
-Sue
On 27 Oct 2003 14:20:35 -0800, guillermoc74@hotmail.com
(Guillermo Casta?o A) wrote:
>Hi, is there a way to have a log of user activity?
>Basically logins and logouts dates and times of each user, on a particular database?
>thanks
- Previous message: Guillermo Casta?o A: "Log of user activity"
- In reply to: Guillermo Casta?o A: "Log of user activity"
- Next in thread: Hari: "Re: Log of user activity"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
