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

[..hidden..]

Revision: 3241
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3241&view=rev
Author:   ehuelsmann
Date:     2011-06-13 20:37:27 +0000 (Mon, 13 Jun 2011)

Log Message:
-----------
Fix bug 3315853: Can't save sales invoice.

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

Modified: trunk/sql/modules/Roles.sql
===================================================================
--- trunk/sql/modules/Roles.sql	2011-06-13 20:26:17 UTC (rev 3240)
+++ trunk/sql/modules/Roles.sql	2011-06-13 20:37:27 UTC (rev 3241)
@@ -188,7 +188,8 @@
 WITH INHERIT NOLOGIN
 IN ROLE "lsmb_<?lsmb dbname ?>__ar_transaction_create";
 
-GRANT INSERT ON invoice, new_shipto 
+--### oldcode: UPDATE granted because old code wants it
+GRANT INSERT, UPDATE ON invoice, new_shipto 
 TO "lsmb_<?lsmb dbname ?>__ar_invoice_create";
 GRANT ALL ON invoice_id_seq TO "lsmb_<?lsmb dbname ?>__ar_invoice_create";
 GRANT INSERT ON inventory TO "lsmb_<?lsmb dbname ?>__ar_invoice_create";


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