Global database read tracking

davmac1 · 2013-12-18

There are global database triggers for tracking inserts, renames, and changes to records, but nothing for tracking reads.
Is there a way at a global level to track reads for the company who wants to track who is looking at what?

I know I could add it to each page, but they are wanting to know if there is anything I can turn on.

kapamarou · 2013-12-18

I don't understand why you need this. Do you mean per record, like User X viewed Order 1,2,7....n?
I can't imagine the overhead this would have.

Instead of tracking access I would simply start by restricting what users see through permissions.

davmac1 · 2013-12-18

I personally think it is a bad idea and I don't think NAV allows for this, but it is what the customer requested. They want to know what people are looking at.
I have asked for, but not received clarification yet, on whether this addresses a specific concern.
A list form reads a lot of records for example. Tracking every single read seems like overkill to me.

bbrown · 2013-12-18

Also keep in mind that just because the system reads a record, it doesn't mean a user looked at that record. For example, a report might read an entire table but only print certain records based on SHOWOUTPUT logic in the report.

aavio · 2013-12-19

Solution should be to restrict users access by setting up proper roles and permissions.

davmac1 · 2013-12-19

Restriction is only the answer if that is the issue.

Global database read tracking

Comments

Categories