Not that I'm aware of.

You might find such capabilities in a third party SQL product such as


Charles Wilt
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121

> -----Original Message-----
> From: Chuck Bower [mailto:cbower@xxxxxxxxxxxx]
> Sent: Tuesday, November 23, 2004 9:21 AM
> To: security400@xxxxxxxxxxxx
> Subject: [Security400] SQL and IT Controls
> Group:
> We are attempting to wrestle with a final Sarbanes Oxley 
> issue relating to SQL, specifically using STRSQL via the 
> command line.  While STRSQL is restricted to those who have a 
> business need to use it, our problem relates to the potential 
> for data manipulation and changes that are not logged.  Our 
> development staff can use it (but not update production data) 
> but our security officers can of course use it, AND update 
> production data.  It is NOT practical for us to journal all 
> of our production data libraries.  While I do have STRSQL 
> command usage logged via the OS/400 audit journal, (we know 
> who uses it and when) it does not provide the log of activity 
> within the STRSQL session.
> Are there any tools on the market that can log the activity 
> within the STRSQL session?   Any feedback you can provide 
> would be GREATLY appreciated!
> Chuck Bower
> VP of IS
> Coachmen Technology Services, Inc.
> _______________________________________________
> This is the Security Administration on the AS400 / iSeries 
> (Security400) mailing list
> To post a message email: Security400@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit:
> or email: Security400-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.