[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 212
  • Last Modified:

How do I mask the input of a column in a table, like a password?

I have a password column in one of my tables. Is it possible to mask the input like a password (*******) so even the system administrator can not see it?

Thanks
0
grouchyfd
Asked:
grouchyfd
  • 3
  • 2
1 Solution
 
JimBrandleyCommented:
I have never see a way to do that. Most of the time, sensitive information is either hashed or encrypted, depending on whether you need to be able to retrieve the plaintext, or simply match it.

For example, a password in a user table is usually hashed. When that user attempts to log in, if the hash of the submitted password matches the hash value stored in the DB, the authorization is granted.

If you need to store a social security number, you need to present it in plaintext when business rules permit, so an encrypted value is stored.

Jim
0
 
grouchyfdAuthor Commented:
So, I as the Sys. Admin, can open up the database table and look up what each individual user's password actually is?
0
 
JimBrandleyCommented:
Correct. Anyone granted read access can get to it.

Jim
0
 
grouchyfdAuthor Commented:
Thank you.I guess I'll have to do some research on encryption.
0
 
JimBrandleyCommented:
Encryption is pretty simple in most applications. Good luck.

Jim
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now