SF.net SVN: ledger-smb:[3723] branches/1.3/sql/modules/Roles.sql

[..hidden..]

Revision: 3723
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3723&view=rev
Author:   einhverfr
Date:     2011-09-20 22:05:41 +0000 (Tue, 20 Sep 2011)
Log Message:
-----------
More changes to support deleting unapproved reconciliation reports

Modified Paths:
--------------
    branches/1.3/sql/modules/Roles.sql

Modified: branches/1.3/sql/modules/Roles.sql
===================================================================
--- branches/1.3/sql/modules/Roles.sql	2011-09-20 22:01:05 UTC (rev 3722)
+++ branches/1.3/sql/modules/Roles.sql	2011-09-20 22:05:41 UTC (rev 3723)
@@ -658,8 +658,11 @@
 GRANT SELECT ON recon_payee 
 TO "lsmb_<?lsmb dbname ?>__reconciliation_approve";
 
+GRANT EXECUTE ON FUNCTION reconciliation__delete_unapproved(in_report_id int)
+TO "lsmb_<?lsmb dbname ?>__reconciliation_approve";
+
 GRANT DELETE ON cr_report_line TO "lsmb_<?lsmb dbname ?>__reconciliation_approve";
-GRANT UPDATE, DELETE ON cr_report TO "lsmb_<?lsmb dbname ?>__reconciliation_approve";
+GRANT UPDATE ON cr_report TO "lsmb_<?lsmb dbname ?>__reconciliation_approve";
 GRANT SELECT ON acc_trans, account_checkpoint TO 
 "lsmb_<?lsmb dbname ?>__reconciliation_approve";
 

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