At 7:24 AM +0500 1/22/01, Muhammad Farhan Ghazi wrote:
>How one can make a field encrypted in a table, so that it cannot
>even be seen using the select statement? I have a field in which I'm
>storing passwords and I don't want it to be visible.
Making it visible or not isn't a matter of encrypting it, it's a matter
of making sure no one has SELECT privleges on it. Use GRANT/REVOKE for
that. I assume you want yourself to have SELECT on it, otherwise the
column won't be very useful ... :-)
--
Paul DuBois, [EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php