Updated Roles.sql to reflect permissions to eca_links

git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2280 4979c152-3d1c-0410-bac9-87ea11338e46

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');