[Users] Column Encryption

[Chris Clark]

Greg Wilding wrote:
>
> Does anybody know if Ingres has any inbuilt tools to Encrypt a column 
> on a database table - we are currently running Ingres 2.6/0205
>

No, at the moment the only option is to implement it yourself :-(. There 
are a few "DIY" techniques available, e.g.

   1. encrypt at the application (or even middleware layer if there is one)
   2. encrypt in the DBMS using rules/triggers and a UDF defined via OME
      http://community.ingres.com/forums/getfilenr.php?durl=50016&lic=none&export=no&frm=pdd
      (i.e. in C).

Option 2 would allow the application to be semi-ignorant that encryption 
is going on, provided the application performs selects on views that 
make decrypt calls on specific columns. Key management would be an issue 
though, so this is far from perfect.

Chris