[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
SF.net SVN: ledger-smb:[4763] branches/1.3/sql/modules/Roles.sql
- Subject: SF.net SVN: ledger-smb:[4763] branches/1.3/sql/modules/Roles.sql
- From: ..hidden..
- Date: Wed, 23 May 2012 10:29:28 +0000
Revision: 4763
http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=4763&view=rev
Author: einhverfr
Date: 2012-05-23 10:29:28 +0000 (Wed, 23 May 2012)
Log Message:
-----------
Correcting missing grant for new_shipto_id_seq
Modified Paths:
--------------
branches/1.3/sql/modules/Roles.sql
Modified: branches/1.3/sql/modules/Roles.sql
===================================================================
--- branches/1.3/sql/modules/Roles.sql 2012-05-23 10:23:11 UTC (rev 4762)
+++ branches/1.3/sql/modules/Roles.sql 2012-05-23 10:29:28 UTC (rev 4763)
@@ -274,7 +274,7 @@
IN ROLE "lsmb_<?lsmb dbname ?>__ar_transaction_create";
--### oldcode: UPDATE granted because old code wants it
-GRANT SELECT, INSERT, UPDATE ON invoice, new_shipto
+GRANT SELECT, INSERT, UPDATE ON invoice, new_shipto, new_shipto_id_seq
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.