From 8e4afbb7a47e5ef8e7b6309d376d449db8b78c9e Mon Sep 17 00:00:00 2001
From: =?utf8?q?S=C3=A9bastien=20Lesaint?=
 <sebastien.lesaint@sonarsource.com>
Date: Fri, 14 Apr 2017 17:50:36 +0200
Subject: [PATCH] SONAR-9140 drop unused SQL query
 selectRootComponentPermissionsOfAnonymous

---
 .../org/sonar/db/permission/AuthorizationMapper.xml       | 8 --------
 1 file changed, 8 deletions(-)

diff --git a/server/sonar-db-dao/src/main/resources/org/sonar/db/permission/AuthorizationMapper.xml b/server/sonar-db-dao/src/main/resources/org/sonar/db/permission/AuthorizationMapper.xml
index eda18667c64..5757414332e 100644
--- a/server/sonar-db-dao/src/main/resources/org/sonar/db/permission/AuthorizationMapper.xml
+++ b/server/sonar-db-dao/src/main/resources/org/sonar/db/permission/AuthorizationMapper.xml
@@ -40,14 +40,6 @@
     gr.group_id is null
   </select>
 
-  <select id="selectRootComponentPermissionsOfAnonymous" parameterType="map" resultType="string">
-    select gr.role
-    from group_roles gr
-    where
-    gr.resource_id=#{rootComponentId,jdbcType=BIGINT} and
-    gr.group_id is null
-  </select>
-
   <select id="countUsersWithGlobalPermissionExcludingGroup" parameterType="map" resultType="int">
     select count(1) from
     (
-- 
2.39.5