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 :)