diff options
author | Leif Johansson <leifj@sunet.se> | 2010-08-04 14:16:01 +0200 |
---|---|---|
committer | Leif Johansson <leifj@sunet.se> | 2010-08-04 14:16:01 +0200 |
commit | dd517c8ac45071516cddbacba26c150a21d7b3ef (patch) | |
tree | e3488f2008e8387c8ae3ec0438122d2157bfa917 | |
parent | d7b39efea9c5e340b06c650bb8ea99f0e91695de (diff) |
sample sql for the shib AA
-rw-r--r-- | docs/shib.sql | 6 |
1 files changed, 6 insertions, 0 deletions
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 |