1 -- This view solves the problem of apache user not being able to access private repositories under
3 -- You MUST replace the markers with your apache user name & user ID
5 CREATE OR REPLACE VIEW "public"."nss_usergroups" (
12 SELECT users.unix_uid AS uid, groups.unix_gid AS gid, users.user_id,
13 groups.group_id, users.user_name
14 FROM users, groups, user_group
15 WHERE (((((users.user_id = user_group.user_id) AND (groups.group_id =
16 user_group.group_id)) AND (groups.status = 'A'::bpchar)) AND (users.status
17 = 'A'::bpchar)) AND ((user_group.cvs_flags = 0) OR (user_group.cvs_flags = 1)))
19 SELECT (INSERT APACHE USER ID HERE!!) AS uid, groups.unix_gid AS gid, NULL::"unknown" AS user_id,
20 NULL::"unknown" AS group_id, '(INSERT APACHE USER NAME HERE!!)' AS user_name
22 WHERE ((groups.enable_anonscm = 0) OR (groups.is_public = 0));