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

[..hidden..]

Revision: 3258
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3258&view=rev
Author:   einhverfr
Date:     2011-06-16 01:16:27 +0000 (Thu, 16 Jun 2011)

Log Message:
-----------
Adding new role for perms for editing orders

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

Modified: trunk/sql/modules/Roles.sql
===================================================================
--- trunk/sql/modules/Roles.sql	2011-06-16 00:04:35 UTC (rev 3257)
+++ trunk/sql/modules/Roles.sql	2011-06-16 01:16:27 UTC (rev 3258)
@@ -271,6 +271,8 @@
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (51, 'allow', 'lsmb_<?lsmb dbname ?>__sales_order_create');
 
+CREATE ROLE "lsmb_<?lsmb dbname ?>__sales_order_edit";
+GRANT DELETE ON orderitems TO "lsmb_<?lsmb dbname ?>__sales_order_edit";
 
 CREATE ROLE "lsmb_<?lsmb dbname ?>__sales_quotation_create"
 WITH INHERIT NOLOGIN
@@ -436,6 +438,9 @@
 GRANT ALL ON orderitems_id_seq TO "lsmb_<?lsmb dbname ?>__purchase_order_create";
 GRANT ALL on inventory TO "lsmb_<?lsmb dbname ?>__purchase_order_create";
 
+CREATE ROLE "lsmb_<?lsmb dbname ?>__purchase_order_edit";
+GRANT DELETE ON orderitems TO "lsmb_<?lsmb dbname ?>__purchase_order_edit";
+
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (50, 'allow', 'lsmb_<?lsmb dbname ?>__purchase_order_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.