Changes between Version 1 and Version 2 of sysadminSeeingWhichGroupsAUserBelongsTo


Ignore:
Timestamp:
Jul 29, 2009, 12:02:19 PM (11 years ago)
Author:
Dan Scott
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • sysadminSeeingWhichGroupsAUserBelongsTo

    v1 v2  
    1616(3 rows)
    1717}}}
     18
     19And work org_units:
     20
     21{{{
     22evergreen=# SELECT aou.name
     23  FROM actor.org_unit aou
     24  INNER JOIN permission.usr_work_ou_map puwm ON puwm.work_ou = aou.id
     25  INNER JOIN actor.usr au ON au.id = puwm.usr
     26  WHERE au.family_name = 'Scott'
     27  AND au.first_given_name = 'Daniel'
     28;
     29          name           
     30-------------------------
     31 J.N. Desmarais Library
     32 Leddy Library
     33 Paul Martin Law Library
     34(3 rows)
     35}}}