masking password in SQL server 2000

[applek]

Hi, all.

Is there anyway to mask the password when writing it to SQL server 2k? Either, can we control the password field in SQL server to be masked whenever data key-in?

Pls advise.

 

[Terpsfan]

In the password text box go to the text box properties, then PasswordChar and you can type in whatever symbol you like -- usually *.

 

[applek]

nope. I mean the field inside the table of SQL Server, not the field in VB design stage.

 

[johnwm]

Don't allow users direct access to SQL tables - only allow access through Views

Check out 'Using Views as Security Mechanisms' in SQL Books on Line, available here:

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'People who live in windowed environments shouldn't cast pointers.'

 

[Foada]

I just encrypt the password from with in my code before I place it in the database, just an idea. If you choose to battle wits with the witless be prepared to lose.