SF.net SVN: ledger-smb:[4941] branches/1.3

[..hidden..]

Revision: 4941
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=4941&view=rev
Author:   einhverfr
Date:     2012-06-21 13:12:54 +0000 (Thu, 21 Jun 2012)
Log Message:
-----------
fixed cannot delete order, 3535856

Modified Paths:
--------------
    branches/1.3/Changelog
    branches/1.3/sql/modules/Roles.sql

Modified: branches/1.3/Changelog
===================================================================
--- branches/1.3/Changelog	2012-06-21 13:01:58 UTC (rev 4940)
+++ branches/1.3/Changelog	2012-06-21 13:12:54 UTC (rev 4941)
@@ -5,6 +5,8 @@
 Changelog for 1.3.20
 * Fixes for es_AR translation, duplicate keys removed (Andres B)
 * Demo templates provide better handling of paragraph breaks in notes (Chris T)
+* Fixed menu anomilies due to menu grants on sub-menus (Chris T)
+* Fixed unable to change order or delete it (Chris T, 3535856)
 
 Changelog for 1.3.19
 * New link for customer/vendor when not a dropdown (Chris T)
@@ -22,7 +24,6 @@
 * Fixed missing grant on partsvendor_entry_id_seq (Chris T, h/t Brian W)
 * Fixed voiding invoice duplicates payment (Chris T h/t John L)
 * Fixed CSV exports not having any data (Chris T h/t Erik H)
-* Fixed menu anomilies due to menu grants on sub-menus (Chris T)
 
 Brian W is Brian Wolf
 Chris T is Chris Travers

Modified: branches/1.3/sql/modules/Roles.sql
===================================================================
--- branches/1.3/sql/modules/Roles.sql	2012-06-21 13:01:58 UTC (rev 4940)
+++ branches/1.3/sql/modules/Roles.sql	2012-06-21 13:12:54 UTC (rev 4941)
@@ -326,9 +326,9 @@
    TO "lsmb_<?lsmb dbname ?>__sales_order_create";
 
 
-GRANT INSERT, UPDATE ON oe TO "lsmb_<?lsmb dbname ?>__sales_order_create";
+GRANT ALL ON oe TO "lsmb_<?lsmb dbname ?>__sales_order_create";
 GRANT ALL ON oe_id_seq TO "lsmb_<?lsmb dbname ?>__sales_order_create";
-GRANT INSERT, UPDATE ON orderitems TO "lsmb_<?lsmb dbname ?>__sales_order_create";
+GRANT ALL 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";
 
@@ -347,7 +347,7 @@
 GRANT "lsmb_<?lsmb dbname ?>__exchangerate_edit"
    TO "lsmb_<?lsmb dbname ?>__sales_quotation_create";
 
-GRANT INSERT, UPDATE ON oe TO "lsmb_<?lsmb dbname ?>__sales_quotation_create";
+GRANT ALL ON oe TO "lsmb_<?lsmb dbname ?>__sales_quotation_create";
 GRANT ALL ON oe_id_seq 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";
@@ -502,8 +502,8 @@
 GRANT "lsmb_<?lsmb dbname ?>__exchangerate_edit"
    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 TO "lsmb_<?lsmb dbname ?>__purchase_order_create";
+GRANT ALL 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";
@@ -524,8 +524,8 @@
 GRANT "lsmb_<?lsmb dbname ?>__exchangerate_edit"
    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 TO "lsmb_<?lsmb dbname ?>__rfq_create";
+GRANT ALL 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.