RE: STRSQL audit log

Or what about Query/400? And WRKDBF? And RUNSQLSTM? Plus, there's always the ability to update a DB2 database from an external source, such as an Excel spreadsheet.

No, I've had auditors ask for stupid things like this before. My question back to them is, "What are you trying to accomplish?" If, for this one, they respond, "To see if anyone is surreptitiously making changes to the database," my response would be the things listed and a few others. And tell them they were attacking the concern from the wrong direction/method.

But to answer your question, I think journaling is what you're looking for.

Jerry C. Adams
IBM System i Programmer/Analyst
B&W Wholesale
office: 615-995-7024
email: jerry@xxxxxxxxxxxxxxx


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Wednesday, May 21, 2008 8:52 AM
To: Midrange Systems Technical Discussion
Subject: Re: STRSQL audit log

So, do they want to log only that and not anything entered via iNav's Run
SQL Scripts?

Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





"Paul E. Fenstermacher" <paulf@xxxxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
05/21/2008 09:05 AM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
"Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
cc

Subject
STRSQL audit log






Our auditors want us to maintain a log of activity around this command
like we can do with DFU and DBU. Anyone know a way to do this? Thanks.



Paul Fenstermacher

Certified Specialist - i5 System Administration

Bass Pro Shops

417-873-5424 d

417-429-7694 c

paulf@xxxxxxxxxxx



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


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