[dba-SQLServer] Who's using my db?

Hi Christopher:

Is it not possible to have the data on the SQL only accessed through SPs or
views. In each of these SPs there would be a function call that would write
a record of it's access to a transaction log table. This technique is done
through all POS systems to track the users, access dates, times and any
changes made to the invoice records.

It all depends on your permissions on the BE.

Jim

> -----Original Message-----
> From: Mackin, Christopher [mailto:CMackin at quiznos.com]
> Sent: Tuesday, December 07, 2004 10:57 AM
> To: dba-sqlserver at databaseadvisors.com
> Subject: [dba-SQLServer] Who's using my db?
>
> Does anyone have any suggestions on how to track/view a log of users
> that have accessed information on the Server and specifically at the
> Database level?
>
> There are users authorized to view a particular db with confidential
> information, and I need to verify that no other users are accessing this
> data.  In this situation it's rather complex because security keeps out
> the majority of people, but there are certain people with the sa
> password and admin rights on the server that should not be looking
> either.
>
> Thanks in advance,
> Chris Mackin