Re: column-level encryption
--0__=09BBE4F3DFC97E058f9e8a93df938690918c09BBE4F3DFC97E05 Content-type: multipart/alternative; Boundary="1__=09BBE4F3DFC97E058f9e8a93df938690918c09BBE4F3DFC97E05" --1__=09BBE4F3DFC97E058f9e8a93df938690918c09BBE4F3DFC97E05 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: quoted-printable Thomas: Column-level encryption will be available in 9.50 release ( next major release). Current 9.3/9.4 server doesn't have this feature. Thanks! -Ping = "Thomas J. = Girsch" = <tgirsch@yahoo.co = To m> informix-list@iiug.org = Sent by: = cc owner-informix-li = st@iiug.org Subj= ect column-level encryption = = 03/22/2004 10:56 = PM = = = Please respond to = "Thomas J. = Girsch" = = = I have a requirement to do column-level encryption in an Informix 9.30.= UC6 database. If possible, I'd like to avoid datablades (although Stored Procedures / Functions would be okay). In a perfect world it would be = a fast algorithm. The encryption algorithm doesn't need to be super-secu= re -- just enough to mask the contents from the casual observer and keep the = data in some format other than readable text. Has anyone already invented this wheel, such that I don't need to re-in= vent it? Any advice or assistance would be greatly appreciated. Oh, and I should mention that for this application, a "secret key" algorithm would be fine. A public key algorithm is probably overkill. Thanks! - Tom Girsch = --1__=09BBE4F3DFC97E058f9e8a93df938690918c09BBE4F3DFC97E05 Content-type: text/html; charset=US-ASCII Content-Disposition: inline Content-transfer-encoding: quoted-printable <html><body> <p>Thomas:<br> <br> Column-level encryption will be available in 9.50 release ( next major = release). Current 9.3/9.4 server doesn't have this feature.<br> <br> Thanks!<br> <br> -Ping<br> <br> <img src=3D"cid:10__=3D09BBE4F3DFC97E058f9e8a93df938@us.ibm.com" width=3D= "16" height=3D"16" alt=3D"Inactive hide details for "Thomas J. Gir= sch" <tgirsch@yahoo.com>">"Thomas J. Girsch" <t= girsch@yahoo.com><br> <br> <br> <table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">= <tr valign=3D"top"><td style=3D"background-image:url(cid:20__=3D09BBE4F= 3DFC97E058f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " wid= th=3D"40%"> <ul> <ul> <ul> <ul><b><font size=3D"2">"Thomas J. Girsch" <tgirsch@yahoo.= com></font></b><font size=3D"2"> </font><br> <font size=3D"2">Sent by: owner-informix-list@iiug.org</font> <p><font size=3D"2">03/22/2004 10:56 PM</font> <table border=3D"1"> <tr valign=3D"top"><td width=3D"168" bgcolor=3D"#FFFFFF"><div align=3D"= center"><font size=3D"2">Please respond to<br> "Thomas J. Girsch"</font></div></td></tr> </table> </ul> </ul> </ul> </ul> </td><td width=3D"60%"> <table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">= <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D09BBE4F3DFC97E058f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""><br> <div align=3D"right"><font size=3D"2">To</font></div></td><td width=3D"= 100%"><img src=3D"cid:30__=3D09BBE4F3DFC97E058f9e8a93df938@us.ibm.com" = border=3D"0" height=3D"1" width=3D"1" alt=3D""><br> <font size=3D"2">informix-list@iiug.org</font></td></tr> <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D09BBE4F3DFC97E058f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""><br> <div align=3D"right"><font size=3D"2">cc</font></div></td><td width=3D"= 100%"><img src=3D"cid:30__=3D09BBE4F3DFC97E058f9e8a93df938@us.ibm.com" = border=3D"0" height=3D"1" width=3D"1" alt=3D""><br> </td></tr> <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D09BBE4F3DFC97E058f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""><br> <div align=3D"right"><font size=3D"2">Subject</font></div></td><td widt= h=3D"100%"><img src=3D"cid:30__=3D09BBE4F3DFC97E058f9e8a93df938@us.ibm.= com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><br> <font size=3D"2">column-level encryption</font></td></tr> </table> <table border=3D"0" cellspacing=3D"0" cellpadding=3D"0"> <tr valign=3D"top"><td width=3D"58"><img src=3D"cid:30__=3D09BBE4F3DFC9= 7E058f9e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt= =3D""></td><td width=3D"336"><img src=3D"cid:30__=3D09BBE4F3DFC97E058f9= e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><= /td></tr> </table> </td></tr> </table> <br> <tt>I have a requirement to do column-level encryption in an Informix 9= .30.UC6<br> database. If possible, I'd like to avoid datablades (although Sto= red<br> Procedures / Functions would be okay). In a perfect world it woul= d be a<br> fast algorithm. The encryption algorithm doesn't need to be super= -secure -- <br> just enough to mask the contents from