public static final String |
DEF_HIERARCHICAL_ROLES_QUERY |
"SELECT a.child_role child, a.parent_role parent FROM ROLES_HIERARCHY a LEFT JOIN ROLES_HIERARCHY b on (a.child_role = b.parent_role) " |
public static final String |
DEF_REGEX_MATCHED_REQUEST_MAPPING_QUERY_ORACLE10G |
"SELECT a.resource_pattern uri, b.authority authority FROM secured_resources a, secured_resources_role b WHERE a.resource_id = b.resource_id AND a.resource_id = ( SELECT resource_id FROM ( SELECT resource_id, ROW_NUMBER() OVER (ORDER BY sort_order) resource_order FROM secured_resources c WHERE REGEXP_LIKE ( :url, c.resource_pattern ) AND c.resource_type = \'url\' ORDER BY c.sort_order ) WHERE resource_order = 1 ) " |
public static final String |
DEF_ROLES_AND_METHOD_QUERY |
"SELECT a.resource_pattern method, b.authority authority FROM SECURED_RESOURCES a, SECURED_RESOURCES_ROLE b WHERE a.resource_id = b.resource_id AND a.resource_type = \'method\' ORDER BY a.sort_order " |
public static final String |
DEF_ROLES_AND_POINTCUT_QUERY |
"SELECT a.resource_pattern pointcut, b.authority authority FROM SECURED_RESOURCES a, SECURED_RESOURCES_ROLE b WHERE a.resource_id = b.resource_id AND a.resource_type = \'pointcut\' ORDER BY a.sort_order " |
public static final String |
DEF_ROLES_AND_URL_QUERY |
"SELECT a.resource_pattern url, b.authority authority FROM SECURED_RESOURCES a, SECURED_RESOURCES_ROLE b WHERE a.resource_id = b.resource_id AND a.resource_type = \'url\' ORDER BY a.sort_order " |