1 DROP TABLE project_perm ;
3 CREATE VIEW project_perm AS
6 role_setting.ref_id AS group_project_id,
8 role_setting.value::int AS perm_level
9 FROM role_setting, user_group
10 WHERE user_group.role_id = role_setting.role_id
11 AND role_setting.section_name='pm';