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

[..hidden..]

Revision: 3681
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3681&view=rev
Author:   einhverfr
Date:     2011-08-24 23:49:12 +0000 (Wed, 24 Aug 2011)
Log Message:
-----------
Permissions fixes from tech support today

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

Modified: trunk/sql/modules/Roles.sql
===================================================================
--- trunk/sql/modules/Roles.sql	2011-08-23 23:37:37 UTC (rev 3680)
+++ trunk/sql/modules/Roles.sql	2011-08-24 23:49:12 UTC (rev 3681)
@@ -931,7 +931,8 @@
 CREATE ROLE "lsmb_<?lsmb dbname ?>__gl_transaction_create"
 WITH INHERIT NOLOGIN;
 
-GRANT INSERT ON gl TO "lsmb_<?lsmb dbname ?>__gl_transaction_create";
+GRANT SELECT, INSERT, UPDATe ON gl 
+TO "lsmb_<?lsmb dbname ?>__gl_transaction_create";
 GRANT INSERT ON acc_trans TO "lsmb_<?lsmb dbname ?>__gl_transaction_create";
 GRANT ALL ON id TO "lsmb_<?lsmb dbname ?>__gl_transaction_create";
 GRANT ALL ON acc_trans_entry_id_seq TO "lsmb_<?lsmb dbname ?>__gl_transaction_create";

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