Password column in a database table

I need to "mask" the password entries in a table. Access has a simple solut
ion but I can not find a way to do this in SQL. This does not have to be enc
rypted, just hid
from the few users we have internally with SQL logins to the database. Any
helpful tips or help files would be much appreciated!No masking available. Hashing, encryption are at your disposal, but better
is you have the option of column level permissions or just simply create a
view without that column and provide these users access to that view.
That's exactly how it is supposed to be done.
hth
Eric
CRouse wrote:
> I need to "mask" the password entries in a table. Access has a
> simple solution but I can not find a way to do this in SQL. This does
> not have to be encrypted, just hid from the few users we have
> internally with SQL logins to the database. Any helpful tips or help
> files would be much appreciated!|||In SQL Server 2000, you can apply column-level permissions or deny those
users select access to the table.
There is no "mask" functionality unless you actually encrypt or encode the
data.
http://www.aspfaq.com/
(Reverse address to reply.)
"CRouse" <CRouse@.discussions.microsoft.com> wrote in message
news:690C479A-498A-470E-B8F2-A8912A5D42EC@.microsoft.com...
> I need to "mask" the password entries in a table. Access has a simple
solution but I can not find a way to do this in SQL. This does not have to
be encrypted, just hid
> from the few users we have internally with SQL logins to the database.
Any helpful tips or help files would be much appreciated!