密码区分大小写 [英] Password with Case-sensitive

问题描述

大家好，



在我现有的oracle会员表中（目前有10万名会员），密码存储在所有大写字母中。



有没有办法将这些密码转换为区分大小写。 （也就是说，用户在注册过程中输入的内容应该按原样存储，我可以为新注册执行此操作，但是我对现有的memebrs有问题）



当用户点击FORGOT PASSWORD链接，它会获取此UPPER CASE密码并显示（我需要在注册时用户输入的任何情况下显示密码）



请指导我如何更新现有的10万用户密码以区分大小写



问候，

Sriram Ravi

Hi All,

In my existing oracle member table(1 lakh members are there currently), password was stored in all upper cases.

Is there any way to convert these passwords to case-sensitive. (that is, what ever user entered during registration should be stored as it is, i can do this for new registration but iam having issues with existing memebrs)

When user clicks on the FORGOT PASSWORD link, it picks up this UPPER CASE password and displaying(i need to display the password in whatever case user enters while registration)

Please guide me on how to update the existing 1 lakh user passwords to case sensitive

Regards,
Sriram Ravi

推荐答案

如果你没有原始密码，那就不可能了！



不要在表格中以明文形式存储密码。你应该把它存储为加密形式。

我建议你阅读它：密码存储：如何做到这一点。 [ ^ ]

If you do not have original passwords, it's impossible!

Do not store passwords as plain text in your table. You should store it as an encrypted form.
I'd suggest you to read it: Password Storage: How to do it.[^]

这篇关于密码区分大小写的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！