MySQL ODBC Connector - Encrypted column example

Author

Encrypted column example

cnelson@nycap.rr.com

2006-02-25, 9:43 am

When 5.0 came out, I saw an article or white paper or something with an
example of a stored procedure (I think, maybe a trigger) that allowed
you to transparently encrypt a column so that even if a database backup
was stolen, that column wouldn't be exposed to the thieves. I believe
that the example was for a SSN or credit card number. Now that I want
it, I can't find it again. I've searched MySQL.com without success.
Does anyone else remember it? Can someone point me to it? Thanks.

Chris

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

sheeri kritzer

2006-02-28, 8:28 pm

Hi Chris,

I remember that article, I think I saw it on PlanetMySQL.com -- but I
can't find it either. I do remember that it encrypted the column
putting it into the database, and used a VIEW to decode it, and then
limited the access to the view.

Hope that helps!

-Sheeri

On 2/23/06, cnelson@nycap.rr.com <cnelson@nycap.rr.com> wrote:
> When 5.0 came out, I saw an article or white paper or something with an
> example of a stored procedure (I think, maybe a trigger) that allowed
> you to transparently encrypt a column so that even if a database backup
> was stolen, that column wouldn't be exposed to the thieves. I believe
> that the example was for a SSN or credit card number. Now that I want
> it, I can't find it again. I've searched MySQL.com without success.
> Does anyone else remember it? Can someone point me to it? Thanks.
>
> Chris
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql? unsub...mail
.com
>
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Sponsored Links