Re: AS/400 Security with ODBC

["John Taylor" <john.taylor@xxxxxxxxxxxxxxx>]

Object authority is the only truly secure way to do it.

Avoid allowing any type of direct update capability from ODBC, unless you're
certain that you can enforce your business rules through triggers or
constraints. The best way to handle the updates is through stored procedures
that adopt authority.

Regards,

John Taylor
Canada

----- Original Message -----
From: <MrLennyB@aol.com>
To: <MIDRANGE-L@midrange.com>
Sent: Friday, June 23, 2000 08:57
Subject: AS/400 Security with ODBC


> We would like to find out what is the best way to control security to the
AS/400 data from ODBC, FTP, Internet, Client Access & who knows what else.
Is it best to use &#8220;Application Only Access&#8221;, Exit Programs, a
combination of both or is there something new available?
>
> Any help would be greatly appreciated.
>
> Thank you
>
> Lenny Bellott
> Shop-Vac Corporation
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
david@midrange.com
> +---

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---