How to mark it down when a user select a field from a table as a log record??

[Mabel]

How to mark it down when a user select a field from a table as a log record??

[David Satz]

you can audit it by creating a stored proc as the only means of access to
the field, but sounds like you are looking at ad-hoc queries in which case,
you should check out SQL Profiler:
http://msdn.microsoft.com/library/de...us/adminsql/ad
_mon_perf_86ib.asp

--
HTH,
David Satz
Principal Web Engineer
Hyperion Solutions

"Mabel" <misuzu129@sinagirl.com> wrote in message
news:3e8bd48f$1@tnews.web.devx.com...
>
> How to mark it down when a user select a field from a table as a log
record??

[Mabel]

how can I do that by using stored procedure??

"David Satz" <davidNOSPAMsatz@yahoo.NOSPAM.com> wrote:
>you can audit it by creating a stored proc as the only means of access to
>the field, but sounds like you are looking at ad-hoc queries in which case,
>you should check out SQL Profiler:
>http://msdn.microsoft.com/library/de...us/adminsql/ad
>_mon_perf_86ib.asp
>
>--
>HTH,
>David Satz
>Principal Web Engineer
>Hyperion Solutions
>
>"Mabel" <misuzu129@sinagirl.com> wrote in message
>news:3e8bd48f$1@tnews.web.devx.com...
>>
>> How to mark it down when a user select a field from a table as a log
>record??
>
>

[David Satz]

you would need to make sure no users have SELECT writes to the table(s)
and/or column(s) and then provide a stored proc to access that table. It is
more of a control access function than log access function, but you can use
it for both, i.e. you can have 2 version of the stored proc: 1 that returns
all columns and 1 that returns all un-logged columns. The latter could
write a row to a table everytime it is run logging the access...

"Mabel" <a@abc.com> wrote in message news:3e8d578a$1@tnews.web.devx.com...
>
> how can I do that by using stored procedure??
>
> "David Satz" <davidNOSPAMsatz@yahoo.NOSPAM.com> wrote:
> >you can audit it by creating a stored proc as the only means of access to
> >the field, but sounds like you are looking at ad-hoc queries in which
case,
> >you should check out SQL Profiler:
>
>http://msdn.microsoft.com/library/de...-us/adminsql/a
d
> >_mon_perf_86ib.asp
> >
> >--
> >HTH,
> >David Satz
> >Principal Web Engineer
> >Hyperion Solutions
> >
> >"Mabel" <misuzu129@sinagirl.com> wrote in message
> >news:3e8bd48f$1@tnews.web.devx.com...
> >>
> >> How to mark it down when a user select a field from a table as a log
> >record??
> >
> >
>