Add group membership query

[freeradius.git] / raddb / sql / mssql / dialup.conf

diff --git a/raddb/sql/mssql/dialup.conf b/raddb/sql/mssql/dialup.conf
index 313fc51..0d824c0 100644 (file)
--- 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