diff options
-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 |