Re: [pgadmin-support] [ADMIN] [PHP] Secure DB Systems - How to

2004-07-13 Thread Mitch Pirtle
Daniel Struck wrote: If you decrypt the data on the database, the sysadmin can see it. Hm, you are right. If one does decrypt the data on the database you have to sent the password to postgresql and so a administrator of the database could easily grasb the password. So the only way to go, wo

Re: [pgadmin-support] [PHP] Secure DB Systems - How to

2004-07-13 Thread Daniel Struck
> If you decrypt the data on the database, the sysadmin can see it. Hm, you are right. If one does decrypt the data on the database you have to sent the password to postgresql and so a administrator of the database could easily grasb the password. So the only way to go, would be to perform en/d

Re: [pgadmin-support] [PHP] Secure DB Systems - How to

2004-07-13 Thread Bruno Wolff III
On Tue, Jul 13, 2004 at 11:35:57 +0200, Daniel Struck <[EMAIL PROTECTED]> wrote: > > Keeping the system administrator from seeing the data while making it > > searchable is difficult. To do this you need to encrypt the data on > > the client side using a key the client has (and this key has to be

Re: [pgadmin-support] [PHP] Secure DB Systems - How to

2004-07-13 Thread Daniel Struck
> Keeping the system administrator from seeing the data while making it > searchable is difficult. To do this you need to encrypt the data on > the client side using a key the client has (and this key has to be > protected from loss) and the only searches you can do are equality > searches using a