Re: how to do an update of the already encrypted data
From: Michel Cadot <micadot{at}altern{dot}org>
Date: Tue, 14 Jul 2015 21:25:36 +0200
Message-ID: <55a56235$0$3325$426a74cc_at_news.free.fr>
| knowing that all columns are encrypted now
| so i need first to decrypte the columns ,then update finally encrypte using the old key stored on image;
| need anwser as soon as possible
| thank you in advance :)
Date: Tue, 14 Jul 2015 21:25:36 +0200
Message-ID: <55a56235$0$3325$426a74cc_at_news.free.fr>
"Sanae" <aithssaine.sanae_at_gmail.com> a écrit dans le message de news: 5cfb507d-e776-498c-b436-facca332c933_at_googlegroups.com...
| Thank's Michel for your replay
| exactly I want to do it manually
| if I am using the trigger before insert and update i can do a simple update
| update emp set prenom='newName';
| but i need to do this
| update emp set prenom=prenom||'Something';
|
| knowing that all columns are encrypted now
| so i need first to decrypte the columns ,then update finally encrypte using the old key stored on image;
| need anwser as soon as possible
| thank you in advance :)
You cannot do this.
You have to write a procedure and something like "set prenom=decrypt(prenom)||'something'".
Regards
Michel
Received on Tue Jul 14 2015 - 21:25:36 CEST