Password column in a database table

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!
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!

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!

Passphrase lost after moving users

I know something like this was addressed before on this forum but I am unable to locate it at all...
Anyone know the solution ?
Problem :
After you move databases to a new server, users may not be able to log in to the new server:
Used DTS ...
Thanks..checkout sp_change_users_login in BOL

sp_change_users_login [ @.Action = ] 'action'
[ , [ @.UserNamePattern = ] 'user' ]
[ , [ @.LoginName = ] 'login' ]
[ , [ @.Password = ] 'password' ]