I really do not know, why you might need such a thing, but one way (with
huge perdormance-penaltiess) to approach this would be to limit the user to
not see any tables, but to encapsulate the table-reading via stored
procedures, which select a table and based on the search-criteria the
result-set gets updated in a plain update-statement and then given back to
the user (as selectable stored proc). Be aware of deadlocks and other
things.
Also, you could create log-tables, where the SP adds an entry for table and
PK of every row supsended in the SP to the user.

Perhaps this can help

Nick Josipovic
CRM Administration
BIT-Institute
Prof. Dr. Franz Steffens
Schloss
68163 Mannheim
Germany
Phone: ++49 621 181-1621
Fax: ++49 621 181-1618
mailto:nick.josipovic@...

> -----Ursprungliche Nachricht-----
> Von: spou@... [mailto:spou@...]
> Gesendet: Mittwoch, 12. September 2001 17:01
> An: IBObjects@yahoogroups.com
> Betreff: [IBO] a way to store "last accessed date"
>
>
> Hi there fellow IBO'ers
>
> I am looking for a way to store, on each record of my table, the date
> this record was last read.
>
> I dont really know where to start, if it is possible, and even if the
> gbak utility would mark a record read on it's daily run.
>
> should it be done in a trigger? by the client itself ? Should I try
> going there via some kind of logs? humm...
>
> This is all higly experimental, let's say. So, all suggestions and
> ideas are welcome.
>
> TIA,
>
> Spou
>
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>