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

[..hidden..]

Revision: 3656
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3656&view=rev
Author:   einhverfr
Date:     2011-08-15 23:19:51 +0000 (Mon, 15 Aug 2011)

Log Message:
-----------
Correcting test failures and fixing bug 3387887

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

Modified: trunk/sql/modules/Roles.sql
===================================================================
--- trunk/sql/modules/Roles.sql	2011-08-15 23:07:17 UTC (rev 3655)
+++ trunk/sql/modules/Roles.sql	2011-08-15 23:19:51 UTC (rev 3656)
@@ -6,7 +6,7 @@
 WITH INHERIT NOLOGIN;
 
 GRANT SELECT ON file_base, file_secondary_attachment, file_transaction,
-file_order, file_links
+file_order, file_links, file_part
       TO "lsmb_<?lsmb dbname ?>__file_read";
 
 CREATE ROLE "lsmb_<?lsmb dbname ?>__file_attach_tx"
@@ -15,6 +15,7 @@
 GRANT INSERT, UPDATE ON file_transaction, file_order_to_tx TO
  "lsmb_<?lsmb dbname ?>__file_attach_tx";
 
+
 CREATE ROLE "lsmb_<?lsmb dbname ?>__file_attach_order"
 WITH INHERIT NOLOGIN;
 
@@ -22,9 +23,23 @@
       ON file_order, 
          file_order_to_order,
          file_tx_to_order
-      TO "lsmb_<?lsmb dbname ?>__file_attach_tx";
+      TO "lsmb_<?lsmb dbname ?>__file_attach_order";
 
+GRANT INSERT, UPDATE ON file_transaction, file_order_to_tx TO
+ "lsmb_<?lsmb dbname ?>__file_attach_tx";
 
+
+CREATE ROLE "lsmb_<?lsmb dbname ?>__file_attach_part"
+WITH INHERIT NOLOGIN;
+
+GRANT INSERT, UPDATE 
+      ON file_part
+      TO "lsmb_<?lsmb dbname ?>__file_attach_part";
+
+
+GRANT ALL ON file_base_id_seq TO "lsmb_<?lsmb dbname ?>__file_attach_tx";
+GRANT ALL ON file_base_id_seq TO "lsmb_<?lsmb dbname ?>__file_attach_part";
+GRANT ALL ON file_base_id_seq TO "lsmb_<?lsmb dbname ?>__file_attach_order";
 -- Contacts
 
 CREATE ROLE "lsmb_<?lsmb dbname ?>__contact_read"

Modified: trunk/sql/modules/Voucher.sql
===================================================================
--- trunk/sql/modules/Voucher.sql	2011-08-15 23:07:17 UTC (rev 3655)
+++ trunk/sql/modules/Voucher.sql	2011-08-15 23:19:51 UTC (rev 3656)
@@ -101,7 +101,7 @@
 			AND a.voucher_id = v.id
 			AND (bc.class like 'receipt%' AND c.link = 'AR')
 		GROUP BY v.id, a.source, cr.meta_number, co.legal_name ,
-                        v.batch_id, v.trans_id, a.transdate, bc.class
+                        a.memo, v.batch_id, v.trans_id, a.transdate, bc.class
 		UNION ALL
 		SELECT v.id, g.reference, g.description, 
 			v.batch_id, v.trans_id,


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