Re: MAPICS - SOX - File auditing

["Phil Campa" <Phil_Campa@xxxxxxxx>]

You can lock the production libraries. This will prevent any back door access
via ODBC or SQL.
There are DBU utilities that provide an audit trail of any updates.



                                                                                
             Greg Wenzloff                                                      
             <GWenzloff@beckmfg.                                                
             com>                                                            To 
             Sent by:                    "'mapics-l@xxxxxxxxxxxx'"              
             mapics-l-bounces@mi         <mapics-l@xxxxxxxxxxxx>                
             drange.com                                                      cc 
                                                                                
                                                                        Subject 
             04/13/2005 08:50 AM         MAPICS - SOX - File auditing           
                                                                                
                                                                                
              Please respond to                                                 
              MAPICS ERP System                                                 
                 Discussion                                                     
             <mapics-l@midrange.                                                
                    com>                                                        
                                                                                
                                                                                




I know this topic has been mentioned before but left dangling I think.

We just got the report on our "practice" SOX audit of controls.  The auditor
(Grant Thornton) says we have a missing control because we do not audit the
MAPICS files for unauthorized access (back door access).   They rated our
front door access (MAPICS user security request forms) as effective.

So I'm back here asking do we really have to turn on the auditing function
in OS400 and log changes to key financial files?  Or perhaps set up triggers
to collect a log. Which files?

I know that no where in the SOX law does it say that this is required, but
if the real auditors do not rate us as having effective controls, I'm in hot
water.

Someone on this list said he has passed several SOX audits with only front
end security controls.   What are the current thoughts on this?

Your comments please.

TIA,
Greg




_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.