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

[..hidden..]

Revision: 3272
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3272&view=rev
Author:   ehuelsmann
Date:     2011-06-17 11:16:17 +0000 (Fri, 17 Jun 2011)

Log Message:
-----------
Clean up 'role already exists' error.

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

Modified: trunk/sql/modules/Roles.sql
===================================================================
--- trunk/sql/modules/Roles.sql	2011-06-17 11:07:24 UTC (rev 3271)
+++ trunk/sql/modules/Roles.sql	2011-06-17 11:16:17 UTC (rev 3272)
@@ -1129,8 +1129,8 @@
 CREATE ROLE "lsmb_<?lsmb dbname ?>__tax_form_save"
 WITH INHERIT NOLOGIN;
 
-GRANT INSERT,  UPDATE ON country_tax_form  
-TO "lsmb_<?lsmb dbname ?>__tax_form_save"; 
+GRANT ALL ON country_tax_form  TO "lsmb_<?lsmb dbname ?>__tax_form_save"; 
+GRANT ALL ON country_tax_form_id_seq TO "lsmb_<?lsmb dbname ?>__tax_form_save";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (218, 'allow', 'lsmb_<?lsmb dbname ?>__tax_form_save');
@@ -1338,13 +1338,7 @@
 IN ROLE "lsmb_<?lsmb dbname ?>__sic_create",
 "lsmb_<?lsmb dbname ?>__sic_edit";
 
-CREATE ROLE "lsmb_<?lsmb dbname ?>__tax_form_save"
-WITH INHERIT NOLOGIN;
 
-GRANT ALL ON country_tax_form TO "lsmb_<?lsmb dbname ?>__tax_form_save";
-GRANT ALL ON country_tax_form_id_seq TO "lsmb_<?lsmb dbname ?>__tax_form_save";
-
-
 CREATE ROLE "lsmb_<?lsmb dbname ?>__template_edit"
 WITH INHERIT NOLOGIN;
 


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