The Academic Initiative website now offers new Informix courses, available in introductory, intermediate, and advanced levels!

https://www14.software.ibm.com/webapp/devtool/scholar/web/coursewarePickPage.do?source=ai-course-dim

Skill Level: Introductory
Informix Structured Query Language V 11.5 (IX130)
Informix Stored Procedures and Triggers V 11.5 (IX711)

Skill Level: Intermediate

This article is written in English and Portuguese
Este artigo está escrito em Inglês e Português

English version:

(german content)

Neue Ausgabe des IBM/Informix Newsletters

Im Newsletter-Archiv befindet sich die neueste Ausgabe des INFORMIX-Newsletters.

Inhaltsverzeichnis der Ausgabe:

This article is written in English and Portuguese
Este artigo está escrito em Inglês e Português

English version:

Introduction

Someone asked me the following question:

"How do I keep passwords in the database so nobody can get them?"

It means that we cannot keep the the passwords in plain text in the database. Informix has a few functions that can be used for encryption: ENCRYPT_AES and ENCRYPT_TDS. It would be easy to create a table and encrypt the column that contains the passwords.

The next statement that came up was: "..but, if someone has the encryption password, he can get all the passwords. We need to protect the passwords from internal access".

Someone asked me the following question:

"How do I keep passwords in the database so nobody can get them?"

It means that we cannot keep the the passwords in plain text in the database. Informix has a few functions that can be used for encryption: ENCRYPT_AES and ENCRYPT_TDS. It would be easy to create a table and encrypt the column that contains the passwords.

The next statement that came up was: "..but, if someone has the encryption password, he can get all the passwords. We need to protect the passwords from internal access".

Below you'll find a guest column from Mr. Wolfgang Kögler, founder and chairmain of ORDIX AG, that critically reviews the open IBM letter to the Informix community:

A german version could be found here: Bewertung des offenen IBM Briefs an die Informix Gemeinde.

(german content)

Nachfolgend ein Gastbeitrag von Herrn Wolfgang Kögler, Gründer und Vorstandsvorsitzender der ORDIX AG, der sich kritisch mit dem öffentlichen IBM Brief an die Informix-Gemeinde auseinandersetzt:

Good article about Informix 11.70 features and their impact on upgrading/reverting an Informix instance: