Re: Log of user activity
From: Hari (hari_prasad_k_at_hotmail.com)
Date: 10/28/03
- Next message: myemail_at_any.where.com: "Wall-paintings, Mural and Monumental Paintings, Frescos"
- Previous message: Sue Hoegemeier: "Re: Log of user activity"
- In reply to: Guillermo Casta?o A: "Log of user activity"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Tue, 28 Oct 2003 11:00:06 +0530
Hi,
Use the profiler and do below to audit the login and logout for a specific
database,
1. In the event class , select Securit audit event clause select
a. Audit Login
b. Audit Logout
2. In the data columns select
a. Loginname
b. start time
c. databasename
3. In the filter set a filter to databasename u need to audit.
Note:
Incase u neeed to audit all the activities u can use C2 Audit feature in SQL
2000 using sp_configure.
Thanks
Hari
MCDBA
"Guillermo Casta?o A" <guillermoc74@hotmail.com> wrote in message
news:9350d78d.0310271420.252b869d@posting.google.com...
> 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
- Next message: myemail_at_any.where.com: "Wall-paintings, Mural and Monumental Paintings, Frescos"
- Previous message: Sue Hoegemeier: "Re: Log of user activity"
- In reply to: Guillermo Casta?o A: "Log of user activity"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
