summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoreinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2008-08-19 16:59:39 +0000
committereinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2008-08-19 16:59:39 +0000
commitf06b4a135fd0efd7792c9ba97df411c441711660 (patch)
tree3149258f32740d9b5b1394e90bd9aa3bcc3d335f
parent682011580e544afe16ffe9b911da8ff84463558d (diff)
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
-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');