[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

Revision: 4671
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=4671&view=rev
Author:   einhverfr
Date:     2012-04-24 10:10:47 +0000 (Tue, 24 Apr 2012)
Log Message:
-----------
Closing bug 3513861, permissions issue creating pricelist

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

Modified: branches/1.3/Changelog
===================================================================
--- branches/1.3/Changelog	2012-04-24 06:58:03 UTC (rev 4670)
+++ branches/1.3/Changelog	2012-04-24 10:10:47 UTC (rev 4671)
@@ -6,6 +6,7 @@
 
 * Changes in <head> element for non-Latin characters, HTML invoices (Erik H)
 * Corrected untranslated string in Contact management screen (Chris T)
+* Corrected permissions issue creating pricelist (Chris T, 3513861)
 
 Changelog for 1.3.15
 * Update WX POS (almost there) - readme and code  (Andres B, item 3516949)

Modified: branches/1.3/sql/modules/Roles.sql
===================================================================
--- branches/1.3/sql/modules/Roles.sql	2012-04-24 06:58:03 UTC (rev 4670)
+++ branches/1.3/sql/modules/Roles.sql	2012-04-24 10:10:47 UTC (rev 4671)
@@ -175,7 +175,6 @@
 WITH INHERIT NOLOGIN
 IN ROLE "lsmb_<?lsmb dbname ?>__contact_read";
 
-GRANT UPDATE ON entity TO "lsmb_<?lsmb dbname ?>__contact_edit";
 GRANT UPDATE ON company TO "lsmb_<?lsmb dbname ?>__contact_edit";
 GRANT UPDATE ON location TO "lsmb_<?lsmb dbname ?>__contact_edit";
 GRANT UPDATE ON person TO "lsmb_<?lsmb dbname ?>__contact_edit";
@@ -833,6 +832,10 @@
 
 GRANT "lsmb_<?lsmb dbname ?>__file_read" TO "lsmb_<?lsmb dbname ?>__part_edit";
 
+GRANT ALL ON partscustomer_entry_id_seq 
+TO "lsmb_<?lsmb dbname ?>__contact_edit", "lsmb_<?lsmb dbname ?>__part_edit";
+
+GRANT UPDATE ON entity TO "lsmb_<?lsmb dbname ?>__contact_edit";
 GRANT SELECT ON assembly, orderitems, jcitems, invoice 
 TO "lsmb_<?lsmb dbname ?>__part_edit";
 

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