SF.net SVN: ledger-smb:[5075] addons/1.3/templatetrans/trunk/sql/modules

[..hidden..]

Revision: 5075
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=5075&view=rev
Author:   einhverfr
Date:     2012-08-01 09:33:59 +0000 (Wed, 01 Aug 2012)
Log Message:
-----------
Adding roles/menu items for template transactions

Added Paths:
-----------
    addons/1.3/templatetrans/trunk/sql/modules/trans-menu.sql
    addons/1.3/templatetrans/trunk/sql/modules/trans-roles.sql

Added: addons/1.3/templatetrans/trunk/sql/modules/trans-menu.sql
===================================================================
--- addons/1.3/templatetrans/trunk/sql/modules/trans-menu.sql	                        (rev 0)
+++ addons/1.3/templatetrans/trunk/sql/modules/trans-menu.sql	2012-08-01 09:33:59 UTC (rev 5075)
@@ -0,0 +1,9 @@
+begin;
+SELECT * FROM menu_insert(0, 18, 'Template Transactions');
+INSERT INTO menu_attribute(node_id, attribute, value)
+VALUES (currval('menu_node_id_seq')::int, 'module', 'transtemplate.pl'),
+       (currval('menu_node_id_seq')::int, 'action', 'display_results');
+
+insert into menu_acl(node_id, role_name, acl_type)
+VALUES (currval('menu_node_id_seq')::int, 'public', 'allow');
+--COMMIT;

Added: addons/1.3/templatetrans/trunk/sql/modules/trans-roles.sql
===================================================================
--- addons/1.3/templatetrans/trunk/sql/modules/trans-roles.sql	                        (rev 0)
+++ addons/1.3/templatetrans/trunk/sql/modules/trans-roles.sql	2012-08-01 09:33:59 UTC (rev 5075)
@@ -0,0 +1,9 @@
+GRANT INSERT ON journal, journal_line, t_invoice
+TO "lsmb_<?lsmb dbname ?>__gl_transaction_create",
+"lsmb_<?lsmb dbname ?>__ar_transaction_create",
+"lsmb_<?lsmb dbname ?>__ap_transaction_create";
+
+GRANT ALL ON journal_id_seq, journal_line_line_id_seq
+TO "lsmb_<?lsmb dbname ?>__gl_transaction_create",
+"lsmb_<?lsmb dbname ?>__ar_transaction_create",
+"lsmb_<?lsmb dbname ?>__ap_transaction_create";

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