Ok.. Will it be secure if the data is encrypted. mysqldump will show
encrypted data right.
Actually I want to know what is the best practice for such applications. Can
I say that encryption alone is sufficient to secure my data. Or is there any
other strategy used for data protection?
----- Original Message -----
From: "Chris" <dmagick@stripped>
To: "Ratheesh K J" <ratheesh.kj@stripped>
Cc: <mysql@stripped>
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 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 other level of security that I can provide to this?
>>
>> Which is the best security technique used in MySQL to store seceret
>> information.
>>
>> PS: Even the database admin should not be able to access anybody else's
>> information
>
> Then you're stuffed - *someone* has to be able to see everything so you
> can do a mysqldump.
>
> *Someone* has to be able to see everything so you can grant permissions to
> the other users too :)
