Re: Data security - help required

2007-05-15 Thread David T. Ashley
On 5/15/07, Ratheesh K J <[EMAIL PROTECTED]> wrote: Hello all, I have a requirement of maintaining some secret information in the database. And this information should not be visible/accessible to any other person but the owner of the data. Whilst I know that encryption/decryption is the soluti

Re: Data security - help required

2007-05-15 Thread Brent Baisley
encrypted data, since at the very least the programmer needs access to it so it can be presented to the user. - Original Message - From: "Ratheesh K J" <[EMAIL PROTECTED]> To: Cc: "Chris" <[EMAIL PROTECTED]> Sent: Tuesday, May 15, 2007 5:19 AM Subject:

Re: Data security - help required

2007-05-15 Thread Mogens Melander
On Tue, May 15, 2007 11:12, Chris wrote: > Ratheesh K J wrote: >> Hello all, >> >> I have a requirement of maintaining some secret information in the >> database. And this information should not be visible/accessible to any >> other person but the owner of the data. >> Whilst I know that encryptio

Re: Data security - help required

2007-05-15 Thread Chris
Ratheesh K J wrote: Ok.. Will it be secure if the data is encrypted. mysqldump will show encrypted data right. mysqldump will show whatever the database table does - it just grabs that info and puts it into a file. If it's encrypted in the table, that's what mysqldump will show. Actually I

Re: Data security - help required

2007-05-15 Thread Mike van Hoof
Well, you can save all data encoded in the database: http://dev.mysql.com/doc/refman/5.0/en/encryption-functions.html#function_encode - Mike Chris schreef: Ratheesh K J wrote: Hello all, I have a requirement of maintaining some secret information in the database. And this information should

Re: Data security - help required

2007-05-15 Thread Ratheesh K J
? - Original Message - From: "Chris" <[EMAIL PROTECTED]> To: "Ratheesh K J" <[EMAIL PROTECTED]> Cc: Sent: Tuesday, May 15, 2007 2:42 PM Subject: Re: Data security - help required Ratheesh K J wrote: Hello all, I have a requirement of maintaining some secret i

Re: Data security - help required

2007-05-15 Thread Chris
Ratheesh K J wrote: Hello all, I have a requirement of maintaining some secret information in the database. And this information should not be visible/accessible to any other person but the owner of the data. Whilst I know that encryption/decryption is the solution for this, are there any oth