| egovframework.rfc3.iam.security.authentication.rememberme.JdbcTokenRepositoryImpl |
public static final java.lang.String |
CREATE_TABLE_SQL |
"create table RFC_COMTNSSO (USER_NAME varchar(64) not null, SERIES varchar(64) primary key, TOKEN varchar(64) not null, LAST_USED timestamp not null,USER_IP varchar(64) not null)" |
public static final java.lang.String |
DEF_INSERT_TOKEN_SQL |
"insert into RFC_COMTNSSO (USER_NAME, SERIES, TOKEN, LAST_USED,USER_IP,USER_REAL_NM ) values(?,?,?,?,?,?)" |
public static final java.lang.String |
DEF_REMOVE_CURRENT_TOKENS_SQL |
"delete from RFC_COMTNSSO where LAST_USED < ?" |
public static final java.lang.String |
DEF_REMOVE_USER_TOKENS_SQL |
"delete from RFC_COMTNSSO where SERIES = ?" |
public static final java.lang.String |
DEF_TOKEN_BY_SERIES_SQL |
"select USER_NAME,SERIES,TOKEN,LAST_USED, USER_IP, USER_REAL_NM from RFC_COMTNSSO where SERIES = ?" |
public static final java.lang.String |
DEF_UPDATE_TOKEN_SQL |
"update RFC_COMTNSSO set TOKEN = ?, LAST_USED = ?, USER_IP=? where SERIES = ?" |
| egovframework.rfc3.iam.security.securedobject.impl.SecuredObjectDAO |
public static final java.lang.String |
DEF_HIERARCHICAL_ROLES_QUERY |
" SELECT \t a.CHILD_ROLE child, \t a.PARENT_ROLE parent FROM \t RFC_COMTNROLES_HIERARCHY a LEFT JOIN RFC_COMTNROLES_HIERARCHY b on (a.CHILD_ROLE = b.PARENT_ROLE) " |
public static final java.lang.String |
DEF_REGEX_MATCHED_REQUEST_MAPPING_QUERY_ORACLE10G |
"SELECT a.RESOURCE_PATTERN method, b.ROLE_ID authority FROM RFC_COMTNRESOURCE a, RFC_COMTNRESOURCE_ROLES b ,RFC_COMTNDOMAIN c WHERE a.RESOURCE_ID = b.RESOURCE_ID AND a.DOMAIN_ID = c.DOMAIN_ID AND a.RESOURCE_TYPE = \'url\' AND c.IS_USE = \'1\' " |
public static final java.lang.String |
DEF_ROLES_AND_METHOD_QUERY |
"SELECT a.RESOURCE_PATTERN method, b.ROLE_ID authority FROM RFC_COMTNRESOURCE a, RFC_COMTNRESOURCE_ROLES b ,RFC_COMTNDOMAIN c WHERE a.RESOURCE_ID = b.RESOURCE_ID AND a.DOMAIN_ID = c.DOMAIN_ID AND a.RESOURCE_TYPE = \'method\' AND c.IS_USE = \'1\' ORDER BY a.SORT_ORDER " |
public static final java.lang.String |
DEF_ROLES_AND_METHOD_QUERY_CUBRID |
"SELECT a.RESOURCE_PATTERN [\'method\'], b.ROLE_ID authority FROM RFC_COMTNRESOURCE a, RFC_COMTNRESOURCE_ROLES b ,RFC_COMTNDOMAIN c WHERE a.RESOURCE_ID = b.RESOURCE_ID AND a.DOMAIN_ID = c.DOMAIN_ID AND a.RESOURCE_TYPE = \'method\' AND c.IS_USE = \'1\' ORDER BY a.SORT_ORDER " |
public static final java.lang.String |
DEF_ROLES_AND_POINTCUT_QUERY |
"SELECT a.RESOURCE_PATTERN pointcut, b.ROLE_ID authority FROM RFC_COMTNRESOURCE a, RFC_COMTNRESOURCE_ROLES b ,RFC_COMTNDOMAIN c WHERE a.RESOURCE_ID = b.RESOURCE_ID AND a.DOMAIN_ID = c.DOMAIN_ID AND a.RESOURCE_TYPE = \'pointcut\' AND c.IS_USE = \'1\' ORDER BY a.SORT_ORDER " |
public static final java.lang.String |
DEF_ROLES_AND_URL_QUERY_CUBRID |
"SELECT case when ROLES.PORT=\'80\' then case ROLES.IS_PERMIT when \'1\' then concat(\'\\\\A\',\'.*.\',ROLES.RESOURCE_PATTERN,\'\\\\Z\') end \t\t when ROLES.PORT=\'443\' then case ROLES.IS_PERMIT when \'1\' then concat(\'\\\\A\',\'.*.\',ROLES.RESOURCE_PATTERN,\'\\\\Z\') else concat(\'\\A\',ROLES.[DOMAIN],ROLES.RESOURCE_PATTERN,\'\\Z\') end \t\telse case ROLES.IS_PERMIT \t\t\twhen \'1\' then concat(\'\\\\A\',\'.*.\',ROLES.RESOURCE_PATTERN,\'\\\\Z\') \t\t\t\t else concat(\'\\\\A\',ROLES.[DOMAIN],\':\',ROLES.PORT,ROLES.RESOURCE_PATTERN,\'\\\\Z\') end end url , ROLES.ROLE_ID authority FROM ( SELECT \t c.[DOMAIN] as [DOMAIN], \t\t\t\t c.PORT as PORT , \t\t\t\t a.RESOURCE_PATTERN as RESOURCE_PATTERN , \t\t\t\t b.ROLE_ID as ROLE_ID , \t\t\t\t a.IS_PERMIT as IS_PERMIT \t FROM \t\t\tRFC_COMTNRESOURCE a INNER JOIN RFC_COMTNRESOURCE_ROLES b ON a.RESOURCE_ID = b.RESOURCE_ID LEFT JOIN RFC_COMTNDOMAIN c ON a.DOMAIN_ID = c.DOMAIN_ID \tWHERE \t\t\t a.RESOURCE_TYPE = \'url\' \t\t\tORDER BY a.SORT_ORDER ASC ) ROLES " |
public static final java.lang.String |
DEF_ROLES_AND_URL_QUERY_MYSQL |
"SELECT case when ROLE.PORT=\'80\' then case ROLE.IS_PERMIT when \'1\' then concat(\'\\\\A\',\'.*.\',ROLE.RESOURCE_PATTERN,\'\\\\Z\') else concat(\'\\\\A\',ROLE.DOMAIN,ROLE.RESOURCE_PATTERN,\'\\\\Z\') end \t\t\t when ROLE.PORT=\'443\' then case ROLE.IS_PERMIT when \'1\' then concat(\'\\\\A\',\'.*.\',ROLE.RESOURCE_PATTERN,\'\\\\Z\') else concat(\'\\A\',ROLE.DOMAIN,ROLE.RESOURCE_PATTERN,\'\\Z\') end \t else case ROLE.IS_PERMIT \t\t\t\t\t when \'1\' then concat(\'\\\\A\',\'.*.\',ROLE.RESOURCE_PATTERN,\'\\\\Z\') \t\t\t\t\t else concat(\'\\\\A\',ROLE.DOMAIN,\':\',ROLE.PORT,ROLE.RESOURCE_PATTERN,\'\\\\Z\') end end url , ROLE.ROLE_ID authority FROM ( SELECT \t c.DOMAIN as DOMAIN,\t\t\t\t\t c.PORT as PORT ,\t\t\t\t\t a.RESOURCE_PATTERN as RESOURCE_PATTERN ,\t\t\t\t\t b.ROLE_ID as ROLE_ID ,\t\t\t\t\t a.IS_PERMIT as IS_PERMIT\t\t FROM \t\t\t\tRFC_COMTNRESOURCE a INNER JOIN RFC_COMTNRESOURCE_ROLES b ON a.RESOURCE_ID = b.RESOURCE_ID LEFT JOIN RFC_COMTNDOMAIN c ON a.DOMAIN_ID = c.DOMAIN_ID \t\t\tWHERE \t\t\t\t a.RESOURCE_TYPE = \'url\' \t\t\t\tORDER BY a.SORT_ORDER ASC ) ROLE " |
public static final java.lang.String |
DEF_ROLES_AND_URL_QUERY_ORACLE |
"SELECT case when ROLE.PORT=\'80\' then case ROLE.IS_PERMIT when \'1\' then \'\\A\' || \'.*.\' || ROLE.RESOURCE_PATTERN || \'\\Z\' else \'\\A\' || ROLE.DOMAIN || ROLE.RESOURCE_PATTERN || \'\\Z\' end \t\t when ROLE.PORT=\'443\' then case ROLE.IS_PERMIT when \'1\' then \'\\A\' || \'.*.\' || ROLE.RESOURCE_PATTERN || \'\\Z\' else \'\\A\' || ROLE.DOMAIN || ROLE.RESOURCE_PATTERN || \'\\Z\' end \t else case ROLE.IS_PERMIT \t\t\t\t\t when \'1\' then \'\\A\' || \'.*.\' || ROLE.RESOURCE_PATTERN || \'\\Z\' \t\t\t\t\t else \'\\A\' || ROLE.DOMAIN || \':\' || ROLE.PORT || ROLE.RESOURCE_PATTERN ||\'\\Z\' end end url , ROLE.ROLE_ID authority FROM ( SELECT \t c.DOMAIN as DOMAIN,\t\t\t\t\t c.PORT as PORT ,\t\t\t\t\t a.RESOURCE_PATTERN as RESOURCE_PATTERN ,\t\t\t\t\t b.ROLE_ID as ROLE_ID ,\t\t\t\t\t a.IS_PERMIT as IS_PERMIT\t\t FROM \t\t\t\tRFC_COMTNRESOURCE a INNER JOIN RFC_COMTNRESOURCE_ROLES b ON a.RESOURCE_ID = b.RESOURCE_ID LEFT JOIN RFC_COMTNDOMAIN c ON a.DOMAIN_ID = c.DOMAIN_ID \t\t\tWHERE \t\t\t\t a.RESOURCE_TYPE = \'url\' \t\t\t\tORDER BY a.SORT_ORDER ASC ) ROLE " |
public static final java.lang.String |
DEF_VIEW_RESOURCE_MAPPING_QUERY |
"SELECT CATEGORY, REF_TYPE,REF_ID,MASK,PERMISSIONS FROM RFC_COMTNVIEWRESOURCEROLE WHERE CATEGORY = :category AND ( \t\t ( REF_ID IN ( {{userRoleList}} ) AND (REF_TYPE = \'ROLE\' OR REF_TYPE = \'OFFICE\') ) \t\tOR ( REF_ID = :userId AND REF_TYPE = \'USER\' ) \t\tOR ( REF_ID = :groupId AND REF_TYPE = \'GROUP\' ) \t) " |