/usr/share/gforge/db/20070924-project-perm.sql is in gforge-db-postgresql 5.1.1-2.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 | DROP TABLE project_perm ;
CREATE VIEW project_perm AS
SELECT
0 AS id,
role_setting.ref_id AS group_project_id,
user_group.user_id,
role_setting.value::int AS perm_level
FROM role_setting, user_group
WHERE user_group.role_id = role_setting.role_id
AND role_setting.section_name='pm';
|