登录用户认证 [英] Login user authentication

问题描述

我想将我的新asp.net新应用程序的用户登录与我的组织ERP用户凭据集成，以便EPR用户可以使用相同的ERP凭据登录asp.net应用程序。



ERP系统的前端是使用Orcale表单开发的，所有ERP用户都是通过ORACLE CREATE USER命令通过ERP用户创建表单创建的，该命令将用户存储在具有密码的oracle dba_users表中。加密形式。



当用户通过输入用户名和密码登录asp.net应用程序时，应用程序连接到oracle数据库，但它没有用户记录由于密码不匹配作为在dba_users表中加密的用户密码。



任何人都可以帮助如何从oracle dba_users表中验证用户名和密码验证指定用户的entery密码有效或无效的方法。

I want to integrate the user login of my new asp.net new application with my organization ERP user credentials so that the EPR users can login on the asp.net application by using the same ERP credentials.

The ERP system's front end is developed by using Orcale form and All the ERP users are created by ERP user creation form via ORACLE CREATE USER command which stores user into in oracle dba_users table having password in the encrypted form.

When user log into the asp.net application by entering its user name and password,the application connect to the oracle data base but it does not fatch user record due to the password mismatch as user password encrypted in dba_users table.

Can any one help as how to verify the user name and password from the oracle dba_users table suggest a way to verify that the entery password for the specified user valid or invalid.

推荐答案

你ha我可以这样做。首先找到用于在oracle表单上加密密码的算法。之后使用相同的算法转换用户输入的密码，并使用从oracle DB中检索到的密码进行检查。如果匹配则OK，否则无法登录。在这里，您不需要使用任何解密密码方案（它与使用SHA1算法时相同。您无法解密）。

You have to do this way. Firstly find the algorithm which used for encrypt the password on oracle forms.After that using the same algorithm convert your user entered password and check it with the retrieved password from the oracle DB.If it's matched then OK else fail to log-in. Here you don't need to use any decrypt password scenario (it's same as when you use the SHA1 Algorithm. You cannot decrypt it).

这篇关于登录用户认证的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！