Tracking user's attempts to access

katisaunders

Does anyone know if there is a way in Navision Attain 3.60 to track which tables a user tries to access. If a user doesn't have access to a table, and they try to access that table thru a form, is there a way to monitor that?

ara3n

If they try to access a table that they don't have permission, they'll get a read permission error.

I guess if you are running sql you could monitor the object table for forms.

kine

Of course, you can use client monitor for tracking which tables are read etc. But it depend on what you need to do...

katisaunders

We are using Attain, not sql. I need to be able to track which tables users are attempting to access. If somebody doesn't have access to the employee table, I need to know if they are trying to access that table thru a form, report etc.

We have Client Monitor but I'm still not sure what the client monitor does? Is it PC specific? Would it be able to write out to a database the attempts by user and table?

kine

Client monitor is gathering informations about database communication of the client. The data are kept in virtual table, but you can copy them into some persistent table (good example is the extended client monitor objects which will process the data and transform them into more readable form).

You can see which table was read, inserted, modified, deleted etc. You can see from which object too (from which trigger etc.). - I recomand you to look for the client monitor fob in download section.

And of course, if you are customer, client monitor need special granule... :-(