Check update fields without audit log

[John91]

Hi there,

I don't check Audit field of sys_user table (collection) but I want to know who changed certain user record and which fields were changed.

Is there any way to confirm?

I suspeced that I could check Transaction Log but it seems not to have such information.

Please let me know.

Thanks.

[Tony Chatfield1 · Accepted solution]

Hi, if you are not auditing the table then I suspect that there is little data available to review.
As you mentioned you might be able to see who navigated to the record (or table) via the transaction logs
You could also check the Event log incase the update generated a sysevent,

You may also be able to search your logs via Node Log File Browser

but these options are less than ideal with visibility limitations and/or time constraints.

Potentially you could also download log files from your instance nodes and search these,
but not very practical if you have a lot of nodes or the log files are large.

As suggest by other users in this thread, I would consider enabling audit on your table so that you don't have this issue in the future.

[John91]

Hi @Tony Chatfield1 ,

I understand that auditing is nesessary when we want to review the detail change.

Now I know that transaction log, event log, and node log file browser (log entry) have less information than auditing.
We will audit sys_user table by now.

Thank you for the detailed answer.
Thank you all 🙂