SF.net SVN: ledger-smb:[3696] trunk

[..hidden..]

Revision: 3696
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3696&view=rev
Author:   einhverfr
Date:     2011-09-10 00:16:16 +0000 (Sat, 10 Sep 2011)
Log Message:
-----------
Correcting error in partsgroup translation permissions

Modified Paths:
--------------
    trunk/dists/source/build.sh
    trunk/sql/modules/Roles.sql

Modified: trunk/dists/source/build.sh
===================================================================
--- trunk/dists/source/build.sh	2011-09-09 21:39:17 UTC (rev 3695)
+++ trunk/dists/source/build.sh	2011-09-10 00:16:16 UTC (rev 3696)
@@ -2,7 +2,7 @@
 
 # Simple script to prepare for release
 
-version="1.3.0_snapshot20110816";
+version="1.3.0_rc1";
 build_d="../release";
 
 if test -d $build_d/ledgersmb; then

Modified: trunk/sql/modules/Roles.sql
===================================================================
--- trunk/sql/modules/Roles.sql	2011-09-09 21:39:17 UTC (rev 3695)
+++ trunk/sql/modules/Roles.sql	2011-09-10 00:16:16 UTC (rev 3696)
@@ -1594,7 +1594,7 @@
 WITH INHERIT NOLOGIN;
 
 GRANT ALL ON project_translation 
-TO "lsmb_<?lsmb dbname ?>__part_translation_create";
+TO "lsmb_<?lsmb dbname ?>__project_translation_create";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (98, 'allow', 'lsmb_<?lsmb dbname ?>__project_translation_create');
@@ -1603,11 +1603,24 @@
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (108, 'allow', 'lsmb_<?lsmb dbname ?>__project_translation_create');
 
+CREATE ROLE "lsmb_<?lsmb dbname ?>__partsgroup_translation_create"
+WITH INHERIT NOLOGIN;
 
+GRANT ALL ON partsgroup_translation
+TO "lsmb_<?lsmb dbname ?>__partsgroup_translation_create";
+INSERT INTO menu_acl (node_id, acl_type, role_name)
+values (98, 'allow', 'lsmb_<?lsmb dbname ?>__partsgroup_translation_create');
+INSERT INTO menu_acl (node_id, acl_type, role_name)
+values (107, 'allow', 'lsmb_<?lsmb dbname ?>__partsgroup_translation_create');
+INSERT INTO menu_acl (node_id, acl_type, role_name)
+values (108, 'allow', 'lsmb_<?lsmb dbname ?>__partsgroup_translation_create');
+
+
 CREATE ROLE "lsmb_<?lsmb dbname ?>__manual_translation_all"
 WITH INHERIT NOLOGIN
 IN ROLE "lsmb_<?lsmb dbname ?>__language_create",
 "lsmb_<?lsmb dbname ?>__part_translation_create",
+"lsmb_<?lsmb dbname ?>__partsgroup_translation_create",
 "lsmb_<?lsmb dbname ?>__project_translation_create";
 
 -- Fixed Assets
@@ -1701,12 +1714,12 @@
 GRANT SELECT ON voucher TO public;
 GRANT select ON account, account_link, account_link_description TO PUBLIC;
 GRANT select ON sic TO public;
-GRANT SELECT ON parts_translation,  project_translation TO public;
+GRANT SELECT ON parts_translation,  partsgroup_translation, 
+                project_translation TO public;
 GRANT SELECT ON asset_report_class, asset_rl_to_disposal_method,
                 asset_disposal_method TO PUBLIC;
 GRANT SELECT ON mime_type, file_class TO PUBLIC;
 
-
 GRANT EXECUTE ON FUNCTION user__get_all_users() TO public;
 
 --TODO, lock recurring, pending_job, payment_queue down more

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