- Question
-
When using general login common component, in case of normal user login, the login process does not work properly.
Please check the problem.
- Answer
-
Hello
"Normal" users to the login process will need to modify the query part.
When you see egovframework/spring/context-security.xml, located in /src/main/resource directory, there is "usersByUsernameQuery" query part for user authentication.
This section will be changed, according to project member management part, later.
In order to handle “normal” user login processing, changes as below
SELECT USER_ID, UNIQ_ID AS PASSWORD, 1 ENABLED, USER_NM, USER_ZIP,
USER_ADRES, USER_EMAIL, USER_SE, ORGNZT_ID, UNIQ_ID,
(select a.ORGNZT_NM from COMTNORGNZTINFO a where a.ORGNZT_ID = ORGNZT_ID) ORGNZT_NM
FROM COMVNUSERMASTER WHERE CONCAT(USER_SE, USER_ID) = ?
|