Erik.
On Tue, Aug 16, 2011 at 1:19 AM,
<..hidden..> wrote:
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.
------------------------------------------------------------------------------
uberSVN's rich system and user administration capabilities and model
configuration take the hassle out of deploying and managing Subversion and
the tools developers use with it. Learn more about uberSVN and get a free
download at: http://p.sf.net/sfu/wandisco-dev2dev
_______________________________________________
Ledger-smb-commits mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-commits