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

[..hidden..]

Revision: 4022
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=4022&view=rev
Author:   einhverfr
Date:     2011-11-21 01:44:06 +0000 (Mon, 21 Nov 2011)
Log Message:
-----------
Correcting permissions bug with partsgroup_id_seq

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

Modified: branches/1.3/Changelog
===================================================================
--- branches/1.3/Changelog	2011-11-21 01:29:57 UTC (rev 4021)
+++ branches/1.3/Changelog	2011-11-21 01:44:06 UTC (rev 4022)
@@ -13,6 +13,7 @@
 * Logging improvements (Herman V)
 * Fixed SQL errors in Goods and Services/All Items report (David B)
 * Corrected issue saving country in contact.html (Pongracz I)
+* Corrected permission denied to partsgroup_id_seq (Chris T)
 
 Chris T is Chris Travers
 David B is David Bandel

Modified: branches/1.3/sql/modules/Roles.sql
===================================================================
--- branches/1.3/sql/modules/Roles.sql	2011-11-21 01:29:57 UTC (rev 4021)
+++ branches/1.3/sql/modules/Roles.sql	2011-11-21 01:44:06 UTC (rev 4022)
@@ -757,7 +757,7 @@
 
 GRANT ALL ON partsvendor, partscustomer TO "lsmb_<?lsmb dbname ?>__part_create";
 GRANT INSERT ON parts, makemodel, partsgroup, assembly TO "lsmb_<?lsmb dbname ?>__part_create";
-GRANT ALL ON parts_id_seq TO "lsmb_<?lsmb dbname ?>__part_create";
+GRANT ALL ON parts_id_seq, partsgroup_id_seq TO "lsmb_<?lsmb dbname ?>__part_create";
 GRANT INSERT ON partstax TO "lsmb_<?lsmb dbname ?>__part_create";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)

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