On Sunday 2002-02-24 at 17:40:47 -0700, Jason Frey wrote:

> > My solution uses AFTER INSERT, AFTER UPDATE and AFTER DELETE triggers,
> > which call a stored procedure, which inserts a row into an audit
> > table. In the case of updates, I insert a row in the audit table for
> > each individual column that changes (mostly, only a small subset of
> > columns get changed in any one update operation).
>
> Is there any sort of trigger akin to AFTER FETCH, or some such, for when a
> person just views a record?

If you think about it, there is really no way the server can tell,
even in theory, whether "a person has viewed a record". So, the answer
is, "The question doesn't make sense."

However, there may be situations where one would want to have certain
things happen if certain information is accessed. Imagine creating a
top-secret database that contains very sensitive information. Perhaps
you would design it so that this info can only be accessed via
selectable stored procedures. These stored procedures could then
implement any sort of logic they like, such as "If accessing the
President's mistress list, fire off a system alert, log an audit
trail, and send an encrypted email to the first lady." Stuff like
that. You get the idea.


David Trudgett