| 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 | | |
|---|
| | 41 | |
|---|
