Link to home
Start Free TrialLog in
Avatar of jdr0606
jdr0606Flag for United States of America

asked on

capture table access

I'm trying to capture user details each time certain tables are accessed.

I've used triggers in the past to capture inserts and updates with user, host, dates etc. detail but not for simple access.

Is there a way to do this.
Avatar of ste5an
ste5an
Flag of Germany image

Take a look at the audit capabilities of SQL Server: SQL Server Audit (Database Engine).
ASKER CERTIFIED SOLUTION
Avatar of Raja Jegan R
Raja Jegan R
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jdr0606

ASKER

This could be my solution however I'm running SQL2014 Standard and this appears to only work on enterprise.
Yes, SQL Server Audit Feature is an Enterprise edition feature whereas Profiler would work fine for any edition of SQL Server