RE: Auditing of SQL Statements via STRSQL

Interesting.....but this is only going to be for a "handful" of users on
our system.
So buying a 3rd party software package is not going to be
cost-effective.


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Matt Graybiel
Sent: Friday, July 08, 2005 9:48 AM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: Auditing of SQL Statements via STRSQL


Jim, there is a third party auditing product from NetIQ (formerly
PentaSafe), called PSAudit, that will audit STRSQL and the statement
submitted.

Matt Graybiel

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
midrange-l-request@xxxxxxxxxxxx
Sent: Friday, July 08, 2005 9:42 AM
To: midrange-l@xxxxxxxxxxxx
Subject: MIDRANGE-L Digest, Vol 4, Issue 1295

Send MIDRANGE-L mailing list submissions to
        midrange-l@xxxxxxxxxxxx

To subscribe or unsubscribe via the World Wide Web, visit
        http://lists.midrange.com/mailman/listinfo/midrange-l
or, via email, send a message with subject or body 'help' to
        midrange-l-request@xxxxxxxxxxxx

You can reach the person managing the list at
        midrange-l-owner@xxxxxxxxxxxx

When replying, please edit your Subject line so it is more specific than
"Re: Contents of MIDRANGE-L digest..."


Today's Topics:

   1. Re: Serial number checking (David Gibbs)
   2. Re: So it looks like it will be called V5R4..... (Dan)
   3. Re: So it looks like it will be called V5R4..... (rob@xxxxxxxxx)
   4. Re: So it looks like it will be called V5R4..... (rob@xxxxxxxxx)
   5. Re: Auditing of SQL Statements via STRSQL (Al Barsa)
   6. Re: Auditing of SQL Statements via STRSQL (rob@xxxxxxxxx)
   7. RE: Auditing of SQL Statements via STRSQL
      (Rick.Chevalier@xxxxxxxxxxxxxxx)
   8. Fwd: IBM Design Change Request MR080404559 (Mitch Davidson)


----------------------------------------------------------------------

message: 1
date: Fri, 08 Jul 2005 08:12:59 -0500
from: David Gibbs <david@xxxxxxxxxxxx>
subject: Re: Serial number checking

James H H Lampert wrote:
> I don't suppose there's any sort of sneaky way to get the serial 
> number of an AS/400 through a TCP connection, without actually signing

> on?

There's no way that I know of to do that using servers that are already
on the system.

You could write your own server program that could be queried with via
TCP/IP.

david