* table

• COMTNROLEINFO
• COMTNAUTHORROLERELATE
• COMTNSECURED_RESOURCES
• COMTNSECURED_RESOURCES_ROLE
• COMTNROLES_HIERARCHY

      /**
       * 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' ";
        
      
      /**
       * 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) ";