blob: b77e71a57f31c6441fc2fb2eaef91e714f2a076b (
plain)
1
2
3
4
5
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;
|