I am looking for options to create a change log and include the user who has updated the data, using a trigger or another method.
This is for additional fields that are not being logged by the standard iMIS change log.
At the trigger level, I am unable to get the individual user who is connected to the database because iMIS is connecting to the database with the same session user id each time. Is there a way to get the user level audit at the trigger level? In the past iMIS 10.6, this wasn't an issue so in the past I could log the entries using a trigger and the session user would reflect accurately who the person is who has changed or added the records.