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

[..hidden..]

Revision: 2692
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2692&view=rev
Author:   jfkw
Date:     2009-06-16 22:10:20 +0000 (Tue, 16 Jun 2009)

Log Message:
-----------
Roles.sql: add GRANTs enabling parts creation.

Add GRANT SELECT ON translation, pricegroup, partstax TO public.

Add GRANT INSERT ON partstax TO __create_part Role.

These missing grants and prevented a user from adding a part, either from the
Add Part interface, or missing part mechanism of Sales Order and Sales Invoice
line item editing.

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

Modified: trunk/sql/modules/Roles.sql
===================================================================
--- trunk/sql/modules/Roles.sql	2009-06-16 17:20:47 UTC (rev 2691)
+++ trunk/sql/modules/Roles.sql	2009-06-16 22:10:20 UTC (rev 2692)
@@ -623,6 +623,7 @@
 
 GRANT INSERT ON parts TO "lsmb_<?lsmb dbname ?>__create_part";
 GRANT ALL ON parts_id_seq TO "lsmb_<?lsmb dbname ?>__create_part";
+GRANT INSERT ON partstax TO "lsmb_<?lsmb dbname ?>__create_part";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (77, 'allow', 'lsmb_<?lsmb dbname ?>__create_part');
@@ -1430,6 +1431,9 @@
 GRANT ALL ON invoice_tax_form TO public;
 GRANT ALL ON ac_tax_form to public;
 GRANT SELECT ON country_tax_form to public;
+GRANT SELECT ON translation TO public;
+GRANT SELECT ON pricegroup TO public;
+GRANT SELECT ON partstax TO public;
 --TODO, lock recurring, pending_job, payment_queue down more
 -- Roles with no db permissions:
 CREATE ROLE "lsmb_<?lsmb dbname ?>__draft_edit" WITH INHERIT NOLOGIN;


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