{{{
    /**
     * url 형식인 보호자원 - Role 맵핑정보를 조회하는 default 쿼리이다.
     */
    public static final String DEF_ROLES_AND_URL_QUERY =                                 
     "SELECT a.ROLE_PTTRN url, b.AUTHOR_CODE authority     "
    +"  FROM COMTNROLEINFO a, COMTNAUTHORROLERELATE b    "
    +" WHERE a.ROLE_CODE = b.ROLE_CODE                   "
    +"   AND a.ROLE_TY = 'url'  ORDER BY a.ROLE_SORT    ";
    
    /**
     * method 형식인 보호자원 - Role 맵핑정보를 조회하는 default 쿼리이다.
     */
    public static final String DEF_ROLES_AND_METHOD_QUERY =
        "SELECT a.ROLE_PTTRN \"method\", b.AUTHOR_CODE authority   "
        +"  FROM COMTNROLEINFO a, COMTNAUTHORROLERELATE b    "
        +" WHERE a.ROLE_CODE = b.ROLE_CODE                   "
        +"   AND a.ROLE_TY = 'method'  ORDER BY a.ROLE_SORT ";    	
    	
    /**
     * pointcut 형식인 보호자원 - Role 맵핑정보를 조회하는 default
     * 쿼리이다.
     */
    public static final String DEF_ROLES_AND_POINTCUT_QUERY =
        "SELECT a.ROLE_PTTRN pointcut, b.AUTHOR_CODE authority   "
        +"  FROM COMTNROLEINFO a, COMTNAUTHORROLERELATE b    "
        +" WHERE a.ROLE_CODE = b.ROLE_CODE                   "
        +"   AND a.ROLE_TY = 'pointcut'  ORDER BY a.ROLE_SORT ";    
    
    /**
     * 매 request 마다 best matching url 보호자원 - Role 맵핑정보를
     * 얻기위한 default 쿼리이다. (Oracle 10g specific)
     */
    public static final String DEF_REGEX_MATCHED_REQUEST_MAPPING_QUERY_ORACLE10G =
        "SELECT a.resource_pattern uri, b.authority authority   "
        + " FROM COMTNSECURED_RESOURCES a, COMTNSECURED_RESOURCES_ROLE b   "
        + " WHERE a.resource_id = b.resource_id   "
        + " AND a.resource_type = 'url' ";

    
    /*****************************************************************
	    "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 ) ";
    */
    
    
    /**
     * Role 의 계층(Hierarchy) 관계를 조회하는 default 쿼리이다.
     */
    public static final String DEF_HIERARCHICAL_ROLES_QUERY =
        "SELECT a.CHLDRN_ROLE child, a.PARNTS_ROLE parent "
        + "FROM COMTNROLES_HIERARCHY a LEFT JOIN COMTNROLES_HIERARCHY b on (a.CHLDRN_ROLE = b.PARNTS_ROLE) ";
}}}