2 UPDATE users SET unix_uid=user_id + 20000 WHERE unix_uid=0;
3 UPDATE users SET unix_gid=unix_uid WHERE unix_gid=0;
8 CREATE VIEW nss_passwd AS
19 WHERE unix_status='A';
21 -- Shadow view (for future use)
24 CREATE VIEW nss_shadow AS
28 CHAR(1) 'n' AS expired,
29 CHAR(1) 'n' AS pwchange
31 WHERE unix_status='A';
34 -- Extracted from group information
36 DROP TABLE nss_groups;
37 CREATE TABLE nss_groups AS
38 SELECT 0 AS user_id, group_id,unix_group_name AS name, group_id + 10000 AS gid
41 -- Insert users group ids in nss_group table
43 INSERT INTO nss_groups (user_id,group_id,name, gid)
44 SELECT user_id,0,user_name, unix_gid
49 -- Insert scm group ids in nss_group table
51 INSERT INTO nss_groups (user_id,group_id,name, gid)
52 SELECT 0,group_id,'scm_' || unix_group_name, group_id + 50000
58 DROP TABLE nss_usergroups ;
59 CREATE TABLE nss_usergroups AS (
61 users.unix_uid AS uid,
62 groups.group_id + 10000 AS gid,
63 users.user_id AS user_id,
64 groups.group_id AS group_id,
65 users.user_name AS user_name,
66 groups.unix_group_name AS unix_group_name
67 FROM users,groups,user_group
69 users.user_id=user_group.user_id
71 groups.group_id=user_group.group_id
80 users.unix_uid AS uid,
81 groups.group_id + 50000 AS gid,
82 users.user_id AS user_id,
83 groups.group_id AS group_id,
84 users.user_name AS user_name,
85 'scm_' || groups.unix_group_name AS unix_group_name
86 FROM users,groups,user_group
88 users.user_id=user_group.user_id
90 groups.group_id=user_group.group_id
98 user_group.cvs_flags > 0);
102 GRANT SELECT ON nss_passwd TO gforge_nss;
103 GRANT SELECT ON nss_groups TO gforge_nss;
104 GRANT SELECT ON nss_usergroups TO gforge_nss;