Masking a column with ****

[unicorn11]

Hi Everybody

I have a column in one of the user tables that hold the passwords. I want to mask it so that it shows "*" when we select it via sql

Regards
Abhishek

Unicorn11
unicorn11@mailcity.com
[red]"Put your hand on a hot stove for a minute, and it seems like an hour. Sit with a pretty girl for an hour, and it seems like a minute. THAT'S relativity." Einstein, Albert[/red]

 

[hymn]

In the table under input mask there the ability for password

Hope this helps
Hymn

 

[unicorn11]

Hi Hymn

Where do I find the input mask?

regards
Abhishek

Unicorn11
unicorn11@mailcity.com
[red]"Put your hand on a hot stove for a minute, and it seems like an hour. Sit with a pretty girl for an hour, and it seems like a minute. THAT'S relativity." Einstein, Albert[/red]

 

[hymn]

Tables
design view
field name/data type

look in the box in the bottom
field size
format
input mask
caption

click on input mask ...
third one down = password

Hope this helps
Hymn

 

[dbomrrsm]

hymn

I think what you are describing is for Access not MS SQL Server

 

[unicorn11]

No I did not find Input Mask. I am using sql server 2000. the columns that I could find are
Description
Default Value
Formula
collation

this is for a varchar problem

regards
Abhishek

Unicorn11
unicorn11@mailcity.com
[red]"Put your hand on a hot stove for a minute, and it seems like an hour. Sit with a pretty girl for an hour, and it seems like a minute. THAT'S relativity." Einstein, Albert[/red]

 

[hymn]

Sorry mate the forum Microsoft SQL Server: Programming has just appeared were the Microsoft: Access Forms were on my threadminder. I don't normally use this forum
oops

Hope this helps
Hymn

 

[dbomrrsm]

thats why you gave the answer you di to my thread about setting a field to NULL !!!

DBomrrsm

 

[ESquared]

Don't give your users access to this table. Instead, create a view of the table that has only the columns you wish to expose.

 

[SQLSister]

You can't put in a mask of passwords in SQL Server. What you do to protect the passwords if you need to is have your user interface run an encryption process when they create a new password or change one. Then you send the encrypted password to the database. Your user interface then encrypts the password when sending it so that it matches what is stored in the database. This is a GUI problem not a SQL Server problem. Encryption algorithms can be quite complex, suggest you read about them on the web.