By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,550 Members | 2,725 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,550 IT Pros & Developers. It's quick & easy.

how to hide password fields when connecting odbc?

P: 76
Hello all,

I have a table for users. One of the fields in this tblUsers has a password field with input mask password.
All is fine through the whole database!

My concern is when I go to excel and do an odbc query through microsoft query, the password field shows th actual letters in the field. As is access it shows ***** but in the ms query it shows e.g apple for the password.

Is there a way that when in ms query the password could still be ***** or just blank or even hidden completely?

It wouldn't help if users can just go ms query and retrieve passwords from there.

Does anyone have suggenstion to do as I explained above or help me approach in a different way!

Thanks
Mar 10 '12 #1
Share this Question
Share on Google+
3 Replies


Rabbit
Expert Mod 10K+
P: 12,366
Plaintext passwords should never be stored. Instead, store the hash.
Mar 11 '12 #2

100+
P: 759
What is "hash", Rabbit ?
Thank you !
Mar 11 '12 #3

Post your reply

Sign in to post your reply or Sign up for a free account.