From 20acc86c988f79f4e65fbc9caaf12f0772b081f5 Mon Sep 17 00:00:00 2001
From: "Alan T. DeKok" <aland@freeradius.org>
Date: Thu, 11 Nov 2010 09:37:04 +0100
Subject: [PATCH] Add group membership query

Closes bug #120
---
 raddb/sql/mssql/dialup.conf | 4 ++++
 1 file changed, 4 insertions(+)

diff --git a/raddb/sql/mssql/dialup.conf b/raddb/sql/mssql/dialup.conf
index 313fc51..0d824c0 100644
--- a/raddb/sql/mssql/dialup.conf
+++ b/raddb/sql/mssql/dialup.conf
@@ -51,6 +51,10 @@
 	authorize_group_check_query = "SELECT ${groupcheck_table}.id,${groupcheck_table}.GroupName,${groupcheck_table}.Attribute,${groupcheck_table}.Value,${groupcheck_table}.op  FROM ${groupcheck_table},${usergroup_table} WHERE ${usergroup_table}.Username = '%{SQL-User-Name}' AND ${usergroup_table}.GroupName = ${groupcheck_table}.GroupName ORDER BY ${groupcheck_table}.id"
 	authorize_group_reply_query = "SELECT ${groupreply_table}.id,${groupreply_table}.GroupName,${groupreply_table}.Attribute,${groupreply_table}.Value,${groupreply_table}.op  FROM ${groupreply_table},${usergroup_table} WHERE ${usergroup_table}.Username = '%{SQL-User-Name}' AND ${usergroup_table}.GroupName = ${groupreply_table}.GroupName ORDER BY ${groupreply_table}.id"
 
+	group_membership_query = "SELECT groupname \
+          FROM ${usergroup_table} \
+          WHERE username = '%{SQL-User-Name}' \
+          ORDER BY priority"
 
 	#######################################################################
 	#  Accounting Queries
-- 
2.1.4