1 CREATE VIEW nss_passwd AS
2 SELECT unix_uid+20000 AS uid,
8 '/var/lib/gforge/chroot/home/users/' || user_name AS homedir
12 SELECT group_id+50000 AS uid,
13 group_id+20000 AS gid,
14 'anoncvs_' || unix_group_name AS login,
15 CHAR(1) 'x' AS passwd,
17 '/bin/false' AS shell,
18 '/var/lib/gforge/chroot/home/groups' || group_name AS homedir
23 'gforge_scm' AS login,
24 CHAR(1) 'x' AS passwd,
25 'Gforge SCM user' AS gecos,
26 '/bin/false' AS shell,
27 '/var/lib/gforge/chroot/home' AS homedir;
29 CREATE VIEW nss_shadow AS
30 SELECT user_name AS login,
32 CHAR(1) 'n' AS expired,
33 CHAR(1) 'n' AS pwchange
37 CREATE VIEW nss_groups AS
38 SELECT group_id+10000 AS gid,
39 unix_group_name AS name,
44 SELECT unix_uid+20000 AS gid,
50 CREATE VIEW nss_usergroups AS
51 SELECT group_id+10000 AS gid,
52 users.unix_uid+20000 AS uid
54 WHERE user_group.user_id=users.user_id
56 SELECT unix_uid+20000 AS gid,
59 -- WHERE group_id!=800 -- drop unused and overfull Debian group