SF.net SVN: ledger-smb:[2280] trunk/sql/modules/Roles.sql

[..hidden..]

Revision: 2280
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2280&view=rev
Author:   einhverfr
Date:     2008-08-19 16:59:39 +0000 (Tue, 19 Aug 2008)

Log Message:
-----------
Updated Roles.sql to reflect permissions to eca_links

Modified Paths:
--------------
    trunk/sql/modules/Roles.sql

Modified: trunk/sql/modules/Roles.sql
===================================================================
--- trunk/sql/modules/Roles.sql	2008-08-18 18:30:00 UTC (rev 2279)
+++ trunk/sql/modules/Roles.sql	2008-08-19 16:59:39 UTC (rev 2280)
@@ -26,6 +26,9 @@
 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,7 +76,13 @@
 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');
 INSERT INTO menu_acl (node_id, acl_type, role_name) 


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.