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

[..hidden..]

Revision: 4367
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=4367&view=rev
Author:   einhverfr
Date:     2012-02-25 14:28:44 +0000 (Sat, 25 Feb 2012)
Log Message:
-----------
adding update permissions on asset_report to depreciate role

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

Modified: branches/1.3/sql/modules/Roles.sql
===================================================================
--- branches/1.3/sql/modules/Roles.sql	2012-02-25 14:23:16 UTC (rev 4366)
+++ branches/1.3/sql/modules/Roles.sql	2012-02-25 14:28:44 UTC (rev 4367)
@@ -1726,9 +1726,8 @@
 CREATE ROLE "lsmb_<?lsmb dbname ?>__assets_depreciate" NOLOGIN INHERIT;
 GRANT SELECT, INSERT ON asset_report, asset_report_line, asset_item, asset_class
 TO "lsmb_<?lsmb dbname ?>__assets_depreciate";
+GRANT UPDATE ON asset_report TO "lsmb_<?lsmb dbname ?>__assets_depreciate";
 
-GRANT EXECUTE ON FUNCTION asset_report__save(
-
 GRANT ALL ON asset_report_id_seq TO "lsmb_<?lsmb dbname ?>__assets_depreciate"; 
 
 INSERT INTO menu_acl(role_name, acl_type, node_id)

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