Re: encrypt/decrypt data before an update/insert

Posted in 2005

Claus Samuelsen — Tue, 15 Feb 2005 23:33:09 +0100 — source: Usenet: comp.databases.informix

Brett Sinclair wrote: > Hello everybody > I'm looking for a way to create a stored procedure that will encrypt > data in a column when doing an update or an insert. > I would need also the decrypt version when doing a select of that > column. > I think I would put that call in a trigger so it would be transparent > to the user. > > Anybody has this type of stored procedure ? > > Regards > Brett > Upgrade to IDS version 10.0, which will be out within 2 weeks. It has column level encryption/decryption.