[Spring Security] COMTNSECURED_RESOURCES 및 COMTNSECURED_RESOURCES_ROLE 테이블 존재하지 않다고 나올때

[Spring Security] COMTNSECURED_RESOURCES 및 COMTNSECURED_RESOURCES_ROLE 테이블 존재하지 않다고 나올때

2017. 7. 18. 17:44ㆍIT개발/Spring & Spring Security

전자정부 3.6버전내용 중 Spring Security 관련 설정 정보에서 존재하지 않는 테이블이 있어 다음과 같이 변경하였더니 오류가 없었다.

context-security.xml

before

sqlRegexMatchedRequestMapping="

SELECT a.resource_pattern uri, b.authority authority

FROM COMTNSECURED_RESOURCES a, COMTNSECURED_RESOURCES_ROLE b

WHERE a.resource_id = b.resource_id

AND a.resource_type = 'url'"

after

sqlRegexMatchedRequestMapping="

SELECT a.ROLE_PTTRN uri, b.AUTHOR_CODE authority

FROM COMTNROLEINFO a, COMTNAUTHORROLERELATE b

WHERE a.ROLE_CODE = b.ROLE_CODE

AND a.ROLE_TY = 'regex'

ORDER BY a.ROLE_SORT"

참고 자료 1. https://open.egovframe.go.kr/cop/bbs/selectBoardArticle.do?bbsId=BBSMSTR_000000000013&nttId=19027

[Spring] @RequestParam Map param - 파라미터를 안줬는데 왜 잘되지? @RequestParam(required=false) 줘야되는거 아니였어? 응 Map은 아니야! (0)	2022.07.18
[spring boot] Reason: Failed to determine suitable jdbc url 또는 jdbcUrl is required with driverClassName 발생시 (0)	2022.01.11
Cannot find the class file for org.springframework.data.domain.Sort. Fix the build path then try building this project (0)	2018.03.12

딸바보아재 개발기