From 8238533b7b1555c348c96c9a0330fb96642d9535 Mon Sep 17 00:00:00 2001 From: Simon Brandhof Date: Thu, 4 Jul 2013 19:42:23 +0200 Subject: [PATCH] Fix PermissionTemplateMapper.xml on Oracle --- .../org/sonar/core/user/PermissionTemplateMapper.xml | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) diff --git a/sonar-core/src/main/resources/org/sonar/core/user/PermissionTemplateMapper.xml b/sonar-core/src/main/resources/org/sonar/core/user/PermissionTemplateMapper.xml index e01b01f683c..0cabe293958 100644 --- a/sonar-core/src/main/resources/org/sonar/core/user/PermissionTemplateMapper.xml +++ b/sonar-core/src/main/resources/org/sonar/core/user/PermissionTemplateMapper.xml @@ -73,9 +73,9 @@ ptu.id AS permission_template_user_id, ptu.permission_reference AS user_permission, u.name AS user_name - FROM permission_templates AS pt - INNER JOIN perm_templates_users AS ptu ON ptu.template_id = pt.id - INNER JOIN users AS u ON u.id = ptu.user_id + FROM permission_templates pt + INNER JOIN perm_templates_users ptu ON ptu.template_id = pt.id + INNER JOIN users u ON u.id = ptu.user_id WHERE pt.name = #{templateName} @@ -88,9 +88,9 @@ ptg.id AS permission_template_group_id, ptg.permission_reference AS group_permission, g.name AS group_name - FROM permission_templates AS pt - INNER JOIN perm_templates_groups AS ptg ON ptg.template_id = pt.id - LEFT OUTER JOIN groups AS g ON g.id = ptg.group_id + FROM permission_templates pt + INNER JOIN perm_templates_groups ptg ON ptg.template_id = pt.id + LEFT OUTER JOIN groups g ON g.id = ptg.group_id WHERE pt.name = #{templateName} -- 2.39.5