From f06b4a135fd0efd7792c9ba97df411c441711660 Mon Sep 17 00:00:00 2001 From: einhverfr Date: Tue, 19 Aug 2008 16:59:39 +0000 Subject: 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 --- sql/modules/Roles.sql | 9 +++++++++ 1 file changed, 9 insertions(+) (limited to 'sql') 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___read_contact"; GRANT SELECT ON person_to_location TO "lsmb___read_contact"; GRANT SELECT ON company_to_location TO "lsmb___read_contact"; GRANT SELECT ON vendortax TO "lsmb___read_contact"; +GRANT SELECT ON eca_to_location TO "lsmb___read_contact"; +GRANT SELECT ON eca_to_contact TO "lsmb___read_contact"; +GRANT EXECUTE ON eca__list_notes(int) TO "lsmb___read_contact"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (1, 'allow', 'lsmb___read_contact'); @@ -73,6 +76,12 @@ GRANT INSERT ON person_to_location TO "lsmb___create_contact"; GRANT INSERT ON company_to_location TO "lsmb___create_contact"; GRANT DELETE ON company_to_location TO "lsmb___create_contact"; GRANT INSERT ON vendortax TO "lsmb___create_contact"; +GRANT INSERT ON eca_to_location TO "lsmb___create_contact"; +GRANT DELETE ON eca_to_location TO "lsmb___create_contact"; +GRANT INSERT ON eca_to_contact TO "lsmb___create_contact"; +GRANT DELETE ON eca_to_contact TO "lsmb___create_contact"; +GRANT INSERT ON eca_note TO "lsmb___create_contact"; + INSERT INTO menu_acl (node_id, acl_type, role_name) values (1, 'allow', 'lsmb___create_contact'); -- cgit v1.2.3