RE: SECURING THE DATABASE

[Chris Bipes <ChrisB@xxxxxxxxxxxxxxx>]

I too have a system that is not secure.  Management wanted the users not to
be able to query the personnel documentation data base.  Level 20 security
makes it hard to restrict access so I created a translate table to mix up
the letters.  A very simple op code jumbles the data enough for every day
users.  Not true encryption,  but perhaps all you need.  Does anyone know if
IBM cryptographic application for communication has API's that can be called
to encrypt data prior to writing to the data base?  That may also give you
what you need.  Best bet is using OS400's security to restrict access to the
data and locking up backup tapes.

Good Luck,

Christopher K. Bipes            mailto:ChrisB@Cross-Check.com
Sr. Programmer/Analyst          mailto:Chris_Bipes@Yahoo.com
CrossCheck, Inc.                        http:\\www.cross-check.com
6119 State Farm Drive           Phone: 707 586-0551 x 1102
Rohnert Park  CA  94928         Fax: 707 586-1884



-----Original Message-----
From: Subhash Dubey [mailto:Subhash.Dubey@bflsoftware.com]
Sent: Tuesday, June 08, 1999 6:22 PM
To: RPG400-L@midrange.com
Subject: SECURING THE DATABASE


I am working on a project that requires database to be encrypted.I would
like to know how to do encryption   with R.P.G /400  . Can we implement
standard encryption algorithm as DES , IDEA , BLOWFISH..Some examples
would be of great help to me.
Thanking you in anticipation
subhash dubey

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the RPG/400 Discussion Mailing List!  To submit a new         *
* message, send your mail to "RPG400-L@midrange.com".  To unsubscribe   *
* from this list send email to MAJORDOMO@midrange.com and specify       *
* 'unsubscribe RPG400-L' in the body of your message.  Questions should *
* be directed to the list owner / operator: david@midrange.com          *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the RPG/400 Discussion Mailing List!  To submit a new         *
* message, send your mail to "RPG400-L@midrange.com".  To unsubscribe   *
* from this list send email to MAJORDOMO@midrange.com and specify       *
* 'unsubscribe RPG400-L' in the body of your message.  Questions should *
* be directed to the list owner / operator: david@midrange.com          *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *