Team,
Is it possible for users to modify any of the downtime data that is being logged? If so, what steps can I take to implement a layer of data verification that ensures the data remains unchanged?
It depends!
Where is it being logged?
Are you using Ignition's Historian or your own table and INSERTs?
Who has access to the database?
Who has access to Designer to run SQL queries?
Ignition as a whole makes database connections. All projects have equal access to the connection's privileges.
The only practical way to constrain what happens is to put triggers in the database to block improper operations. (Reject UPDATE, conditionally reject INSERT, on tables of concern.)
2 Likes
We've had good success with database triggers automatically logging the timestamp, type of change and user ID making the edit (or interfacing application)..
On critical tables, you can also log the history of changes by writing what the data was before the edit and compare the delta between the current record and the data in a "tablename_HIST" table with three additional columns: CHANGE_DTS, CHANGE_TYPE, CHANGE_USER
1 Like