Index: base3.10/src/main/java/egovframework/com/uss/umt/web/EgovUserManageController.java =================================================================== --- base3.10/src/main/java/egovframework/com/uss/umt/web/EgovUserManageController.java (revision 115) +++ base3.10/src/main/java/egovframework/com/uss/umt/web/EgovUserManageController.java (revision 116) @@ -167,6 +167,7 @@ // 사용자 등록 권한을 위한 권한 리스트를 가지고 온다 AuthorManageVO authorManageVO = new AuthorManageVO(); authorManageVO.setPagingAt(false); + authorManageVO.setSearchCondition("999"); authorManageVO.setAuthorManageList(egovAuthorManageService.selectAuthorList(authorManageVO)); model.addAttribute("authorList", authorManageVO.getAuthorManageList()); @@ -270,6 +271,7 @@ // 사용자 등록 권한을 위한 권한 리스트를 가지고 온다 AuthorManageVO authorManageVO = new AuthorManageVO(); authorManageVO.setPagingAt(false); + authorManageVO.setSearchCondition("999"); authorManageVO.setAuthorManageList(egovAuthorManageService.selectAuthorList(authorManageVO)); model.addAttribute("authorList", authorManageVO.getAuthorManageList()); Index: base3.10/src/main/resources/egovframework/mapper/com/sec/ram/EgovAuthorManage_SQL_postgres.xml =================================================================== --- base3.10/src/main/resources/egovframework/mapper/com/sec/ram/EgovAuthorManage_SQL_postgres.xml (revision 115) +++ base3.10/src/main/resources/egovframework/mapper/com/sec/ram/EgovAuthorManage_SQL_postgres.xml (revision 116) @@ -15,8 +15,12 @@ AUTHOR_CODE, AUTHOR_NM, AUTHOR_DC, AUTHOR_CREAT_DE FROM COMTNAUTHORINFO WHERE 1=1 - <if test="searchCondition == 1">AND - (AUTHOR_NM LIKE CONCAT('%' , #{searchKeyword}, '%') OR AUTHOR_CODE LIKE CONCAT('%' , #{searchKeyword}, '%')) + <if test="searchCondition == 1"> + AND (AUTHOR_NM LIKE CONCAT('%' , #{searchKeyword}, '%') OR AUTHOR_CODE LIKE CONCAT('%' , #{searchKeyword}, '%')) + </if> + <!-- 게시판 등록 시 필요없는 권한 제외 --> + <if test="searchCondition == 999"> + AND AUTHOR_CODE NOT IN ('ROLE_RESTRICTED','ROLE_ANONYMOUS','IS_AUTHENTICATED_ANONYMOUSLY','IS_AUTHENTICATED_FULLY','IS_AUTHENTICATED_REMEMBERED','ROLE_DISTEACHER') </if> ORDER BY AUTHOR_CREAT_DE DESC <if test="pagingAt == true">