Logging of DBA activity for SOX

Posted in 2006

SteveT68@gmail.com — 31 Jul 2006 05:21:05 -0700 — source: Usenet: comp.databases.informix

Hi Guys, I am not an Informix DBA, but have been challenged with implementing a logging solution for Sarbanes Oxley compliance. What we would like to do is log all activity on the database by the Informix DBA's. In particular, we would like to include log on/off activity, plus all scripts run by the DBA during their connection. As you will see from the above, I am no expert, in fact have never touched Informix! What I am after is some background info, to help me guide the DBA's in order that they do not just tell me "it can't be done". Our Log collection tool, will be Network Intelligence enVision, which supports logs from syslog, or ftp of text files from a server, or ODBC connection to a table in the DB. By the way, we have similar challenges with Oracle and SQL! Any assistance would be much appreciated. Steve