Our company uses AS400 for our financial processing application. The users access the AS400 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 AS400 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.