SF.net SVN: ledger-smb:[4268] addons/1.3/import_trans/trunk/sql/modules/ import-trans-menu.sql

[..hidden..]

Revision: 4268
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=4268&view=rev
Author:   einhverfr
Date:     2012-01-20 06:46:30 +0000 (Fri, 20 Jan 2012)
Log Message:
-----------

Adding role additions to menu setup for import transaction script

Modified Paths:
--------------
    addons/1.3/import_trans/trunk/sql/modules/import-trans-menu.sql

Modified: addons/1.3/import_trans/trunk/sql/modules/import-trans-menu.sql
===================================================================
--- addons/1.3/import_trans/trunk/sql/modules/import-trans-menu.sql	2012-01-20 06:42:31 UTC (rev 4267)
+++ addons/1.3/import_trans/trunk/sql/modules/import-trans-menu.sql	2012-01-20 06:46:30 UTC (rev 4268)
@@ -35,4 +35,12 @@
 insert into menu_attribute (node_id, attribute, value)
 select node_id, 'action', 'begin_import'
 from menu_node_temp where description in ('ap', 'gl');
+
+INSERT INTO menu_acl (role_name, acl_type, node_id)
+SELECT CASE WHEN description = 'gl' 
+            THEN 'lsmb_'||current_database()||'__gl_transaction_create'
+            WHEN description = 'ap'
+            THEN 'lsmb_'||current_database()||'__ap_transaction_create'
+            END, 'allow', node_id
+  FROM menu_node_temp  where description in ('ap', 'gl');
 COMMIT;

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