Michael L.
Well Known Member
Hi List,
We’ve just been audited and as a result the auditors have made the following request. When our developers change any records any table in Production using SQL (either from 5250 and/or ops nav), we need to capture the log file showing the actual SQL statement used to change the table.
Do you know what change I can make to the developers ‘400’ user profile and/or setting(s) / in System i Navigator I can make so that I can capture the SQL’s in the log files if the SQL is run from 'green screen or Ops Nav?
My apologies for inquiring here instead of the ‘400’ forum but that forum isn’t reviewed much.
Thanks in advance for any assistance,
Michael
E1 9.0, TR 8.98.4.7, V6R1
We’ve just been audited and as a result the auditors have made the following request. When our developers change any records any table in Production using SQL (either from 5250 and/or ops nav), we need to capture the log file showing the actual SQL statement used to change the table.
Do you know what change I can make to the developers ‘400’ user profile and/or setting(s) / in System i Navigator I can make so that I can capture the SQL’s in the log files if the SQL is run from 'green screen or Ops Nav?
My apologies for inquiring here instead of the ‘400’ forum but that forum isn’t reviewed much.
Thanks in advance for any assistance,
Michael
E1 9.0, TR 8.98.4.7, V6R1
