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, paul@stripped
