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
_______________________________________________
Users mailing list
[email protected]
http://lists.ingres.com/mailman/listinfo/users
