General login is not normally processed.
- 작성자
- 관리자
- 작성일자
- 2012-04-18
- 조회수
- 4,458
Q
When using general login common component, in case of normal user login, the login process does not work properly.
Please check the problem.
A
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) = ?
"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) = ?