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

[..hidden..]

Revision: 2834
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2834&view=rev
Author:   einhverfr
Date:     2009-12-22 19:46:39 +0000 (Tue, 22 Dec 2009)

Log Message:
-----------
fixing more permissions grants

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

Modified: trunk/sql/modules/Roles.sql
===================================================================
--- trunk/sql/modules/Roles.sql	2009-12-22 19:44:12 UTC (rev 2833)
+++ trunk/sql/modules/Roles.sql	2009-12-22 19:46:39 UTC (rev 2834)
@@ -549,7 +549,10 @@
 CREATE ROLE "lsmb_<?lsmb dbname ?>__reconciliation_enter"
 WITH INHERIT NOLOGIN;
 
- GRANT INSERT ON cr_reports TO "lsmb_<?lsmb dbname ?>__reconciliation_enter";
+ GRANT INSERT ON cr_report, cr_report_line 
+TO "lsmb_<?lsmb dbname ?>__reconciliation_enter";
+GRANT DELETE ON cr_report_line
+TO "lsmb_<?lsmb dbname ?>__reconciliation_enter";
 GRANT SELECT ON acc_trans TO "lsmb_<?lsmb dbname ?>__reconciliation_enter";
  GRANT ALL ON cr_reports_id_seq TO "lsmb_<?lsmb dbname ?>__reconciliation_enter";
 
@@ -562,7 +565,7 @@
 CREATE ROLE "lsmb_<?lsmb dbname ?>__reconciliation_approve"
 WITH INHERIT NOLOGIN;
 
-GRANT UPDATE ON cr_reports TO "lsmb_<?lsmb dbname ?>__reconciliation_enter";
+GRANT UPDATE ON cr_report TO "lsmb_<?lsmb dbname ?>__reconciliation_enter";
 GRANT SELECT ON acc_trans TO "lsmb_<?lsmb dbname ?>__reconciliation_enter";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)


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