ACS3 Data Model

     1: function ad_admin_group_member_p
     2:   (v_module IN varchar,
     3:    v_submodule IN varchar,
     4:    v_user_id IN integer)
     5: return varchar
     6: IS
     7:   n_rows  integer;
     8: BEGIN
     9:   select count(*) into n_rows
    10:    from user_group_map
    11:    where user_id = v_user_id
    12:    and group_id in (select group_id from administration_info
    13:                     where (module = v_module and submodule = v_submodule)
    14:                     or module = 'site_wide');
    15:   IF n_rows > 0 THEN
    16:     return 't';
    17:   ELSE
    18:     return 'f';
    19:   END IF;
    20: END;