RE: Adopted Authority and Client Server applications

On the iSeries ODBC events flow through exit points 

        QIBM_QZDA_SQL1 format ZDAQ0100
        QIBM_QZDA_SQL2 format ZDAQ0200

In SQL1 up to 512 bytes of the SQL string is passed to the exit program.
In SQL2 up to 32K of the SQL string is passed to the exit program.
Since you have the SQL string you can do whatever you want with it.

You can write your own exit program, or look at one of the commercial
intrusion detection/ prevention products on the market.

-----Original Message-----
From: Vance Stanley [mailto:w_vance_stanley@xxxxxxxxx] 
Sent: Thursday, November 13, 2003 12:04 PM
To: Midrange Systems Technical Discussion
Subject: RE: Adopted Authority and Client Server applications


I am not sure if I know what database exit points are.

--- Gary Monnier <gary.monnier@xxxxxxxxxxxxx> wrote:
> Vance,
> 
> Have you thought of using the database exit points?
> 
> -----Original Message-----
> From: Vance Stanley [mailto:w_vance_stanley@xxxxxxxxx] 
> Sent: Thursday, November 13, 2003 7:19 AM
> To: Midrange Systems Technical Discussion
> Subject: Adopted Authority and Client Server applications
> 
> 
> 
>   We are trying to implement a client server app that is using odbc to
> access the 400. The 400's
> database is using adopted authority to handle security.  Is there
> another way other than an
> additional authorization list to allow the client app. to update the
> 400?  
> 
> Thanks,
> 
> 
> =====
> W. Vance Stanley
> Sr. Programmer Analyst
> DEVON Houston, Texas
> 713-507-5536
> 
> __________________________________
> Do you Yahoo!?
> Protect your identity with Yahoo! Mail AddressGuard
> http://antispam.yahoo.com/whatsnewfree
> _______________________________________________
> 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.
> 


__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree
_______________________________________________
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.