롤이 변경될때마다 서버에서 롤정보를 다시 읽어오는 방법
- 작성자 :
- 초***다
- 작성일 :
- 2018-05-03 17:57:41
- 조회수 :
- 1,701
- 구분 :
- 기타
- 진행상태 :
- 완료
Q
해당 에러입니다..
2018-05-03 17:36:57,461 DEBUG [org.springframework.security.web.access.intercept.FilterSecurityInterceptor] Secure object: FilterInvocation: URL: /uat/uia/actionLogout.do; Attributes: [ROLE_test3, ROLE_ANONYMOUS, ROLE_ADMIN, ROLE_test2, ROLE_test]
2018-05-03 17:36:57,461 DEBUG [org.springframework.security.web.access.intercept.FilterSecurityInterceptor] Previously Authenticated: org.springframework.security.authentication.UsernamePasswordAuthenticationToken@c4aaf88b: Principal: egovframework.rte.fdl.security.userdetails.EgovUserDetails@6924de4: Username: test6; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true; credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities: ROLE_test6; Credentials: [PROTECTED]; Authenticated: true; Details:
롤을 변경할때마다 서버를 재시작하지않는이상 처음켰을때의 롤정보만 계속쥐고있습니다..
롤을 변경할때마다 서버의 롤새션을 다시 불러들이는 방법이있을까요 ?
아래는 이가브 셋팅부분입니다.
<egov-security:secured-object-config id="securedObjectConfig"
sqlRolesAndUrl="SELECT a.ROLE_PTTRN url, b.AUTHOR_CODE authority FROM MN_ROLEINFO a, MN_AUTHORROLERELATE b WHERE a.ROLE_CODE = b.ROLE_CODE AND a.ROLE_TY = 'url' ORDER BY a.ROLE_SORT"
sqlRolesAndMethod="SELECT a.ROLE_PTTRN "method", b.AUTHOR_CODE authority FROM MN_ROLEINFO a, MN_AUTHORROLERELATE b WHERE a.ROLE_CODE = b.ROLE_CODE AND a.ROLE_TY = 'method' ORDER BY a.ROLE_SORT"
sqlRolesAndPointcut="SELECT a.ROLE_PTTRN pointcut, b.AUTHOR_CODE authority FROM MN_ROLEINFO a, MN_AUTHORROLERELATE b WHERE a.ROLE_CODE = b.ROLE_CODE AND a.ROLE_TY = 'pointcut' ORDER BY a.ROLE_SORT"
sqlRegexMatchedRequestMapping="SELECT a.resource_pattern uri, b.authority authority FROM MN_SECURED_RESOURCES a, MN_SECURED_RESOURCES_ROLE b WHERE a.resource_id = b.resource_id AND a.resource_type = 'url'"
sqlHierarchicalRoles="SELECT a.CHLDRN_ROLE child, a.PARNTS_ROLE parent FROM MN_ROLES_HIERARCHY a LEFT JOIN MN_ROLES_HIERARCHY b on (a.CHLDRN_ROLE = b.PARNTS_ROLE)"
/>
2018-05-03 17:36:57,461 DEBUG [org.springframework.security.web.access.intercept.FilterSecurityInterceptor] Secure object: FilterInvocation: URL: /uat/uia/actionLogout.do; Attributes: [ROLE_test3, ROLE_ANONYMOUS, ROLE_ADMIN, ROLE_test2, ROLE_test]
2018-05-03 17:36:57,461 DEBUG [org.springframework.security.web.access.intercept.FilterSecurityInterceptor] Previously Authenticated: org.springframework.security.authentication.UsernamePasswordAuthenticationToken@c4aaf88b: Principal: egovframework.rte.fdl.security.userdetails.EgovUserDetails@6924de4: Username: test6; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true; credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities: ROLE_test6; Credentials: [PROTECTED]; Authenticated: true; Details:
롤을 변경할때마다 서버를 재시작하지않는이상 처음켰을때의 롤정보만 계속쥐고있습니다..
롤을 변경할때마다 서버의 롤새션을 다시 불러들이는 방법이있을까요 ?
아래는 이가브 셋팅부분입니다.
<egov-security:secured-object-config id="securedObjectConfig"
sqlRolesAndUrl="SELECT a.ROLE_PTTRN url, b.AUTHOR_CODE authority FROM MN_ROLEINFO a, MN_AUTHORROLERELATE b WHERE a.ROLE_CODE = b.ROLE_CODE AND a.ROLE_TY = 'url' ORDER BY a.ROLE_SORT"
sqlRolesAndMethod="SELECT a.ROLE_PTTRN "method", b.AUTHOR_CODE authority FROM MN_ROLEINFO a, MN_AUTHORROLERELATE b WHERE a.ROLE_CODE = b.ROLE_CODE AND a.ROLE_TY = 'method' ORDER BY a.ROLE_SORT"
sqlRolesAndPointcut="SELECT a.ROLE_PTTRN pointcut, b.AUTHOR_CODE authority FROM MN_ROLEINFO a, MN_AUTHORROLERELATE b WHERE a.ROLE_CODE = b.ROLE_CODE AND a.ROLE_TY = 'pointcut' ORDER BY a.ROLE_SORT"
sqlRegexMatchedRequestMapping="SELECT a.resource_pattern uri, b.authority authority FROM MN_SECURED_RESOURCES a, MN_SECURED_RESOURCES_ROLE b WHERE a.resource_id = b.resource_id AND a.resource_type = 'url'"
sqlHierarchicalRoles="SELECT a.CHLDRN_ROLE child, a.PARNTS_ROLE parent FROM MN_ROLES_HIERARCHY a LEFT JOIN MN_ROLES_HIERARCHY b on (a.CHLDRN_ROLE = b.PARNTS_ROLE)"
/>
A
안녕하십니까, 표준프레임워크센터입니다.
자주 묻는 질문을 참고해주시기 바랍니다.
제한적인 관리자 정책
https://www.egovframe.go.kr/uss/olh/faq/FaqInqireCoUpdt.do?menu=5&submenu=3
모든 권한 관리자 정책
https://www.egovframe.go.kr/uss/olh/faq/FaqInqireCoUpdt.do?menu=5&submenu=3
#권한 재시작관련 글
http://www.egovframe.go.kr//uss/olh/qna/QnaInqireCoUpdt.do?qaId=QA_00000000000014508&pageIndex=2
감사합니다.
자주 묻는 질문을 참고해주시기 바랍니다.
제한적인 관리자 정책
https://www.egovframe.go.kr/uss/olh/faq/FaqInqireCoUpdt.do?menu=5&submenu=3
모든 권한 관리자 정책
https://www.egovframe.go.kr/uss/olh/faq/FaqInqireCoUpdt.do?menu=5&submenu=3
#권한 재시작관련 글
http://www.egovframe.go.kr//uss/olh/qna/QnaInqireCoUpdt.do?qaId=QA_00000000000014508&pageIndex=2
감사합니다.