RE: STRSQL audit log

Yeah, our auditors are like that: Reading from a script.

Auditors are not a necessary evil; they are necessary. I have worked with some real duds and some great ones. The latter sit down with the client and (a) explain "Why" they want something, and (b) listen and learn. I worked with a great one years ago who, if he had made a request to audit usage of any command, would have listened and reflected after I noted (as others have done here) the numerous backdoors available to circumvent his motives. John would have then revised his request to a more reasonable and practical objective.

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 Paul E. Fenstermacher
Sent: Wednesday, May 21, 2008 9:32 PM
To: Midrange Systems Technical Discussion
Subject: RE: STRSQL audit log

Remember, they are auditors and know very little about what they want.
They have certain things that they most likely ask every client to
produce without regard to whether or not they are actually getting
anything that really helps the client protect themselves.

Paul Fenstermacher
Certified Specialist - i5 System Administration
Bass Pro Shops
417-873-5424 d
417-429-7694 c
paulf@xxxxxxxxxxx


-----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.

--
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.