Audit access to column on a table

  • Has anyone implemented a process to audit users/logins accessing a column on a table -- or access to the table itself?

    Here is my Users request:

    I was asked if we could track if users use a specific table column. For example, the question we’d like to answer is “how many users query PeopleData.source.users.Position_Title?”

    Would there be any concern as to how quickly the trace file would grow if we were to trace at that level?

    BT
  • I like this post: http://www.bradmcgehee.com/2010/03/an-introduction-to-sql-server-2008-audit/

    Simple instructions (w/ GUI screen snaps) to setup a SQL 2008:

    1) Audit

    2) Audit Spec

    BT

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply