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

[..hidden..]

Revision: 3587
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3587&view=rev
Author:   einhverfr
Date:     2011-07-28 21:43:49 +0000 (Thu, 28 Jul 2011)

Log Message:
-----------
Permissions fixes for updating orders

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

Modified: trunk/sql/modules/Roles.sql
===================================================================
--- trunk/sql/modules/Roles.sql	2011-07-28 00:47:27 UTC (rev 3586)
+++ trunk/sql/modules/Roles.sql	2011-07-28 21:43:49 UTC (rev 3587)
@@ -307,9 +307,9 @@
 WITH INHERIT NOLOGIN
 IN ROLE "lsmb_<?lsmb dbname ?>__contact_read";
 
-GRANT INSERT ON oe TO "lsmb_<?lsmb dbname ?>__sales_order_create";
+GRANT INSERT, UPDATE ON oe TO "lsmb_<?lsmb dbname ?>__sales_order_create";
 GRANT ALL ON oe_id_seq TO "lsmb_<?lsmb dbname ?>__sales_order_create";
-GRANT INSERT ON orderitems TO "lsmb_<?lsmb dbname ?>__sales_order_create";
+GRANT INSERT, UPDATE ON orderitems TO "lsmb_<?lsmb dbname ?>__sales_order_create";
 GRANT ALL ON orderitems_id_seq TO "lsmb_<?lsmb dbname ?>__sales_order_create";
 GRANT ALL on inventory TO "lsmb_<?lsmb dbname ?>__sales_order_create";
 
@@ -326,9 +326,9 @@
 WITH INHERIT NOLOGIN
 IN ROLE "lsmb_<?lsmb dbname ?>__contact_read";
 
-GRANT INSERT ON oe TO "lsmb_<?lsmb dbname ?>__sales_quotation_create";
+GRANT INSERT, UPDATE ON oe TO "lsmb_<?lsmb dbname ?>__sales_quotation_create";
 GRANT ALL ON oe_id_seq TO "lsmb_<?lsmb dbname ?>__sales_quotation_create";
-GRANT INSERT ON orderitems TO "lsmb_<?lsmb dbname ?>__sales_quotation_create";
+GRANT INSERT, UPDATE ON orderitems TO "lsmb_<?lsmb dbname ?>__sales_quotation_create";
 GRANT ALL ON orderitems_id_seq TO "lsmb_<?lsmb dbname ?>__sales_quotation_create";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
@@ -488,8 +488,8 @@
 WITH INHERIT NOLOGIN
 IN ROLE "lsmb_<?lsmb dbname ?>__contact_read";
 
-GRANT INSERT ON oe TO "lsmb_<?lsmb dbname ?>__purchase_order_create";
-GRANT INSERT ON orderitems TO "lsmb_<?lsmb dbname ?>__purchase_order_create";
+GRANT INSERT, UPDATE ON oe TO "lsmb_<?lsmb dbname ?>__purchase_order_create";
+GRANT INSERT, UPDATE ON orderitems TO "lsmb_<?lsmb dbname ?>__purchase_order_create";
 GRANT ALL ON oe_id_seq TO "lsmb_<?lsmb dbname ?>__purchase_order_create";
 GRANT ALL ON orderitems_id_seq TO "lsmb_<?lsmb dbname ?>__purchase_order_create";
 GRANT ALL on inventory TO "lsmb_<?lsmb dbname ?>__purchase_order_create";
@@ -508,8 +508,8 @@
 WITH INHERIT NOLOGIN
 IN ROLE "lsmb_<?lsmb dbname ?>__contact_read";
 
-GRANT INSERT ON oe TO "lsmb_<?lsmb dbname ?>__rfq_create";
-GRANT INSERT ON orderitems TO "lsmb_<?lsmb dbname ?>__rfq_create";
+GRANT INSERT, UPDATE ON oe TO "lsmb_<?lsmb dbname ?>__rfq_create";
+GRANT INSERT, UPDATE ON orderitems TO "lsmb_<?lsmb dbname ?>__rfq_create";
 GRANT ALL ON oe_id_seq TO "lsmb_<?lsmb dbname ?>__rfq_create";
 GRANT ALL ON orderitems_id_seq TO "lsmb_<?lsmb dbname ?>__rfq_create";
 


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