| | 1 | |
|---|
| | 2 | |
|---|
| | 3 | {{{ |
|---|
| | 4 | /** |
|---|
| | 5 | * url 형식인 보호자원 - Role 맵핑정보를 조회하는 default 쿼리이다. |
|---|
| | 6 | */ |
|---|
| | 7 | public static final String DEF_ROLES_AND_URL_QUERY = |
|---|
| | 8 | "SELECT a.ROLE_PTTRN url, b.AUTHOR_CODE authority " |
|---|
| | 9 | +" FROM COMTNROLEINFO a, COMTNAUTHORROLERELATE b " |
|---|
| | 10 | +" WHERE a.ROLE_CODE = b.ROLE_CODE " |
|---|
| | 11 | +" AND a.ROLE_TY = 'url' ORDER BY a.ROLE_SORT "; |
|---|
| | 12 | |
|---|
| | 13 | /** |
|---|
| | 14 | * method 형식인 보호자원 - Role 맵핑정보를 조회하는 default 쿼리이다. |
|---|
| | 15 | */ |
|---|
| | 16 | public static final String DEF_ROLES_AND_METHOD_QUERY = |
|---|
| | 17 | "SELECT a.ROLE_PTTRN \"method\", b.AUTHOR_CODE authority " |
|---|
| | 18 | +" FROM COMTNROLEINFO a, COMTNAUTHORROLERELATE b " |
|---|
| | 19 | +" WHERE a.ROLE_CODE = b.ROLE_CODE " |
|---|
| | 20 | +" AND a.ROLE_TY = 'method' ORDER BY a.ROLE_SORT "; |
|---|
| | 21 | |
|---|
| | 22 | /** |
|---|
| | 23 | * pointcut 형식인 보호자원 - Role 맵핑정보를 조회하는 default |
|---|
| | 24 | * 쿼리이다. |
|---|
| | 25 | */ |
|---|
| | 26 | public static final String DEF_ROLES_AND_POINTCUT_QUERY = |
|---|
| | 27 | "SELECT a.ROLE_PTTRN pointcut, b.AUTHOR_CODE authority " |
|---|
| | 28 | +" FROM COMTNROLEINFO a, COMTNAUTHORROLERELATE b " |
|---|
| | 29 | +" WHERE a.ROLE_CODE = b.ROLE_CODE " |
|---|
| | 30 | +" AND a.ROLE_TY = 'pointcut' ORDER BY a.ROLE_SORT "; |
|---|
| | 31 | |
|---|
| | 32 | /** |
|---|
| | 33 | * 매 request 마다 best matching url 보호자원 - Role 맵핑정보를 |
|---|
| | 34 | * 얻기위한 default 쿼리이다. (Oracle 10g specific) |
|---|
| | 35 | */ |
|---|
| | 36 | public static final String DEF_REGEX_MATCHED_REQUEST_MAPPING_QUERY_ORACLE10G = |
|---|
| | 37 | "SELECT a.resource_pattern uri, b.authority authority " |
|---|
| | 38 | + " FROM COMTNSECURED_RESOURCES a, COMTNSECURED_RESOURCES_ROLE b " |
|---|
| | 39 | + " WHERE a.resource_id = b.resource_id " |
|---|
| | 40 | + " AND a.resource_type = 'url' "; |
|---|
| | 41 | |
|---|
| | 42 | |
|---|
| | 43 | /***************************************************************** |
|---|
| | 44 | "SELECT a.resource_pattern uri, b.authority authority " |
|---|
| | 45 | + "FROM secured_resources a, secured_resources_role b " |
|---|
| | 46 | + "WHERE a.resource_id = b.resource_id " |
|---|
| | 47 | + "AND a.resource_id = " |
|---|
| | 48 | + " ( SELECT resource_id FROM " |
|---|
| | 49 | + " ( SELECT resource_id, ROW_NUMBER() OVER (ORDER BY sort_order) resource_order FROM secured_resources c " |
|---|
| | 50 | + " WHERE REGEXP_LIKE ( :url, c.resource_pattern ) " |
|---|
| | 51 | + " AND c.resource_type = 'url' " |
|---|
| | 52 | + " ORDER BY c.sort_order ) " |
|---|
| | 53 | + " WHERE resource_order = 1 ) "; |
|---|
| | 54 | */ |
|---|
| | 55 | |
|---|
| | 56 | |
|---|
| | 57 | /** |
|---|
| | 58 | * Role 의 계층(Hierarchy) 관계를 조회하는 default 쿼리이다. |
|---|
| | 59 | */ |
|---|
| | 60 | public static final String DEF_HIERARCHICAL_ROLES_QUERY = |
|---|
| | 61 | "SELECT a.CHLDRN_ROLE child, a.PARNTS_ROLE parent " |
|---|
| | 62 | + "FROM COMTNROLES_HIERARCHY a LEFT JOIN COMTNROLES_HIERARCHY b on (a.CHLDRN_ROLE = b.PARNTS_ROLE) "; |
|---|
| | 63 | }}} |
|---|
