From db19e222c5c7b9564ab13e096faa03cf69772701 Mon Sep 17 00:00:00 2001
From: Julien Lancelot <julien.lancelot@gmail.com>
Date: Wed, 14 Aug 2013 18:17:41 +0200
Subject: [PATCH] Fix SQL for Oracle

---
 .../src/main/resources/org/sonar/core/user/RoleMapper.xml       | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/sonar-core/src/main/resources/org/sonar/core/user/RoleMapper.xml b/sonar-core/src/main/resources/org/sonar/core/user/RoleMapper.xml
index 7d7e9b075f7..be4b7671b5d 100644
--- a/sonar-core/src/main/resources/org/sonar/core/user/RoleMapper.xml
+++ b/sonar-core/src/main/resources/org/sonar/core/user/RoleMapper.xml
@@ -109,7 +109,7 @@
       AND (gr.role=#{permission} AND gr.resource_id IS NULL)
       AND u.active=${_true}
     </where>
-    ) AS tmp
+    ) tmp
   </select>
 
 </mapper>
-- 
2.39.5