• Subject: Re: Limiting SQL Access
  • From: MacWheel99@xxxxxxx
  • Date: Tue, 28 Nov 2000 13:39:00 EST

You can setup your library list so that in front of the library with the IBM 
command "STRSQL" or any other IBM command for that matter, is your own 
command with the identical name ... it does in fact run the IBM command, but 
before doing so, it does something that you want done, such as verification 
that the user meets some authority standards that you not want to put in 
using standard security techniques.

You can also change some attributes of any IBM command, which I do not 
reccommend due to complexities associated with OS/400 upgrades ... I cannot 
remember the precise command to do this.  You could copy duplicate object 
STRSQL to your up front library list then change the attributes of the copy, 
but you really need to put this in a CL which will rerun after any future 
OS/400 upgrade.

Check archives on Security topics ,,, lots of nuances to learn.

>  From:    christophe.wenk@kuehne-nagel.com (Jnb ZI, Christophe Wenk)
>  <head></head>I would like to restrict the usage of SQL. Since we had some 
> abuse on SQL 
>  I would like to have a  Validity checking program on Userprofiles 
>  when executing STRSQL.
>  Does anybody have something like that ?
>  Thanks a lot
>  Chris

MacWheel99@aol.com (Alister Wm Macintyre) (Al Mac)
AS/400 Data Manager & Programmer for BPCS 405 CD Rel-02 mixed mode (twinax 
interactive & batch) @ http://www.cen-elec.com Central Industries of 
Indiana--->Quality manufacturer of wire harnesses and electrical 
sub-assemblies - fax # 812-424-6838

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


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].