SF.net SVN: ledger-smb:[4378] addons/1.3/budgetting/branches/1.0/sql/ modules/Budgetting-roles.sql

[..hidden..]

Revision: 4378
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=4378&view=rev
Author:   einhverfr
Date:     2012-03-04 13:42:25 +0000 (Sun, 04 Mar 2012)
Log Message:
-----------
Fixing permissions for budgetting roles

Modified Paths:
--------------
    addons/1.3/budgetting/branches/1.0/sql/modules/Budgetting-roles.sql

Modified: addons/1.3/budgetting/branches/1.0/sql/modules/Budgetting-roles.sql
===================================================================
--- addons/1.3/budgetting/branches/1.0/sql/modules/Budgetting-roles.sql	2012-03-04 13:36:50 UTC (rev 4377)
+++ addons/1.3/budgetting/branches/1.0/sql/modules/Budgetting-roles.sql	2012-03-04 13:42:25 UTC (rev 4378)
@@ -1,11 +1,12 @@
 --TODO
 CREATE ROLE "lsmb_<?lsmb dbname ?>__budget_enter" WITH INHERIT NOLOGIN;
+CREATE ROLE "lsmb_<?lsmb dbname ?>__budget_view" WITH INHERIT NOLOGIN;
 CREATE ROLE "lsmb_<?lsmb dbname ?>__budget_approve" WITH INHERIT NOLOGIN;
 CREATE ROLE "lsmb_<?lsmb dbname ?>__budget_obsolete" WITH INHERIT NOLOGIN;
 
 GRANT SELECT 
 ON budget_info, budget_line, budget_to_department, budget_to_project
-TO public;
+TO "lsmb_<?lsmb dbname ?>__budget_view";
 
 GRANT INSERT 
 ON budget_info, budget_line, budget_to_department, budget_to_project 

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