SQLTeam.com | Weblogs | Forums

Monitoring/Log access to a Database


#1

Hi,
what possibilities there are to monitors access to a database. It is to be recorded, which user or client accesses it. And not on all tables, only tables to a certain scheme.
Background: The database will soon be switched off...
Thanks and
Regards
Nicole :wink:


#2

you can use SQL Trace to log any activity on that database