From dd517c8ac45071516cddbacba26c150a21d7b3ef Mon Sep 17 00:00:00 2001
From: Leif Johansson <leifj@sunet.se>
Date: Wed, 4 Aug 2010 14:16:01 +0200
Subject: sample sql for the shib AA

---
 docs/shib.sql | 6 ++++++
 1 file changed, 6 insertions(+)
 create mode 100644 docs/shib.sql

(limited to 'docs/shib.sql')

diff --git a/docs/shib.sql b/docs/shib.sql
new file mode 100644
index 0000000..b77e71a
--- /dev/null
+++ b/docs/shib.sql
@@ -0,0 +1,6 @@
+
+SQL for shibboleth AA resolver:
+
+select n.display as eduPersonEntitlement from membership_membership as m, auth_user as u, name_name as n, userprofile_userprofile as p 
+   where m.user_id=u.id and p.user_id=u.id and p.identifier='$identifier' 
+   and m.enabled=1 and m.hidden=0 and (m.expires is NULL or m.expires < date()) and n.id=m.name_id;
\ No newline at end of file
-- 
cgit v1.1

