summaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/modules/Roles.sql9
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/modules/Roles.sql b/sql/modules/Roles.sql
index c6d79af2..ebffc13b 100644
--- a/sql/modules/Roles.sql
+++ b/sql/modules/Roles.sql
@@ -26,6 +26,9 @@ GRANT SELECT ON person_to_location TO "lsmb_<?lsmb dbname ?>__read_contact";
GRANT SELECT ON person_to_location TO "lsmb_<?lsmb dbname ?>__read_contact";
GRANT SELECT ON company_to_location TO "lsmb_<?lsmb dbname ?>__read_contact";
GRANT SELECT ON vendortax TO "lsmb_<?lsmb dbname ?>__read_contact";
+GRANT SELECT ON eca_to_location TO "lsmb_<?lsmb dbname ?>__read_contact";
+GRANT SELECT ON eca_to_contact TO "lsmb_<?lsmb dbname ?>__read_contact";
+GRANT EXECUTE ON eca__list_notes(int) TO "lsmb_<?lsmb dbname ?>__read_contact";
INSERT INTO menu_acl (node_id, acl_type, role_name)
values (1, 'allow', 'lsmb_<?lsmb dbname ?>__read_contact');
@@ -73,6 +76,12 @@ GRANT INSERT ON person_to_location TO "lsmb_<?lsmb dbname ?>__create_contact";
GRANT INSERT ON company_to_location TO "lsmb_<?lsmb dbname ?>__create_contact";
GRANT DELETE ON company_to_location TO "lsmb_<?lsmb dbname ?>__create_contact";
GRANT INSERT ON vendortax TO "lsmb_<?lsmb dbname ?>__create_contact";
+GRANT INSERT ON eca_to_location TO "lsmb_<?lsmb dbname ?>__create_contact";
+GRANT DELETE ON eca_to_location TO "lsmb_<?lsmb dbname ?>__create_contact";
+GRANT INSERT ON eca_to_contact TO "lsmb_<?lsmb dbname ?>__create_contact";
+GRANT DELETE ON eca_to_contact TO "lsmb_<?lsmb dbname ?>__create_contact";
+GRANT INSERT ON eca_note TO "lsmb_<?lsmb dbname ?>__create_contact";
+
INSERT INTO menu_acl (node_id, acl_type, role_name)
values (1, 'allow', 'lsmb_<?lsmb dbname ?>__create_contact');