Data Encryption

Posted in 2000

Topics: Security, Permissions & Auditing

mdelerme@my-deja.com — Fri, 28 Jul 2000 15:31:06 GMT — source: Informix-list mailing list archive (1991-1998)

Hi all, Wanted to know if there is a way to encrypt the data on a column on the DB side? Basicly, I has a password column and what it to encrypt the values. Any ideas? Or would it just be easier to have the client encript the data before inserting to the DB? I'm running IIF v9.20 on VA Linux. Thanks in advance. Marco Sent via Deja.com http://www.deja.com/ Before you buy.

↪ replying to mdelerme@my-deja.com

Steve Waggoner — Fri, 28 Jul 2000 16:00:10 GMT — source: Informix-list mailing list archive (1991-1998)

IMHO I would encrypt the passwords on the client side. I use a message digest function (MD5) to encryted to password the second the user types it in. The program would then just store and compare hashed values instead of real passwords. <mdelerme@my-deja.com> wrote in message news:8ls8vq$k7b$1@nnrp1.deja.com... > Hi all, > > Wanted to know if there is a way to encrypt the data on a column on the > DB side? Basicly, I has a password column and what it to encrypt the > values. Any ideas? Or would it just be easier to have the client > encript the data before inserting to the DB? I'm running IIF v9.20 on > VA Linux. Thanks in advance. > > Marco > > > Sent via Deja.com http://www.deja.com/ > Before you buy.

↪ replying to Steve Waggoner

mdelerme@my-deja.com — Fri, 28 Jul 2000 16:47:57 GMT — source: Informix-list mailing list archive (1991-1998)

Currently that is how we are doing it on one system. The question was posed to me if it could be done on the DB side by adding a constraint. In article <e6ig5.54821$3E6.579893@news1.alsv1.occa.home.com>, "Steve Waggoner" <steve.dot.waggoner@integtech.dot.com> wrote: > IMHO > > I would encrypt the passwords on the client side. I use a message > digest function (MD5) to encryted to password the second the > user types it in. The program would then just store and compare > hashed values instead of real passwords. > > <mdelerme@my-deja.com> wrote in message news:8ls8vq$k7b$1@nnrp1.deja.com... > > Hi all, > > > > Wanted to know if there is a way to encrypt the data on a column on the > > DB side? Basicly, I has a password column and what it to encrypt the > > values. Any ideas? Or would it just be easier to have the client > > encript the data before inserting to the DB? I'm running IIF v9.20 on > > VA Linux. Thanks in advance. > > > > Marco > > > > > > Sent via Deja.com http://www.deja.com/ > > Before you buy. > > Sent via Deja.com http://www.deja.com/ Before you buy.

↪ replying to Steve Waggoner

Zafar — Mon, 07 Aug 2000 07:48:36 -0700 — source: Informix-list mailing list archive (1991-1998)

Hi, How can I encrypt the data in the table. We are running Informix 8.2UD5X1. * Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful

↪ replying to Zafar

Art S. Kagel — Thu, 10 Aug 2000 09:29:29 -0400 — source: Informix-list mailing list archive (1991-1998)

Unless you have 9.xx and build a data encryption DataBlade, or find one to buy, you will have to encrypt the data before inserting it. If you do that be careful, character columns are DEFINED as containing a NULL if the first byte is a zero (0x0) byte. Also if the column can contain zero bytes in other characters your host variables will have to be defined as FIXCHAR or their contents will truncate on load at the first zero byte. Art S. Kagel Zafar wrote: > > Hi, > How can I encrypt the data in the table. We are running > Informix 8.2UD5X1. > > * Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful