List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:January 22 2001 2:30am
Subject:Re: encrypted fields
View as plain text  
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
Thread
encrypted fieldsMuhammad Farhan Ghazi22 Jan
  • Re: encrypted fieldsPaul DuBois22 Jan
  • Re: encrypted fieldsCurtis Maurand22 Jan