Our company uses AS/400 for our financial processing application. The users access the AS/400 through an emulator. They also access the application database through ODBC. They extract the data to excel sheets to create certain reports for their own purpose.
Recently, one the data base files in AS/400 were replaced by such a user accidentally. However, since we do not have log for this, we are not sure who did this or how this happened. Can you tell me how can we control the data access to our database files through ODBC? Also, can we change any settings so that a log is created every time a user accesses the database files through ODBC?
Thanks for all the help.