Change a few permission levels and assignments
authorDan Wells <dbw2@calvin.edu>
Wed, 1 Jun 2011 13:43:53 +0000 (09:43 -0400)
committerDan Wells <dbw2@calvin.edu>
Wed, 1 Jun 2011 16:43:50 +0000 (12:43 -0400)
In an attempt to be consistent with existing perms, a few were moved to
levels lower than 'Consortium', and ADMIN_SERIAL_ITEM is only in the
'Serial' group.

Signed-off-by: Dan Wells <dbw2@calvin.edu>
Signed-off-by: Jason Etheridge <jason@esilibrary.com>

Open-ILS/src/sql/Pg/upgrade/0542.data.perm-list.misc-cat.sql

index 603c827..3e3bfae 100644 (file)
@@ -57,7 +57,7 @@ INSERT INTO permission.grp_perm_map ( grp, perm, depth )
     SELECT
         5,
         id,
-        0
+        2
     FROM permission.perm_list
     WHERE code in (
         'MARK_ITEM_MISSING_PIECES'
@@ -83,11 +83,10 @@ INSERT INTO permission.grp_perm_map ( grp, perm, depth )
     SELECT
         5,
         id,
-        0
+        1
     FROM permission.perm_list
     WHERE code in (
         'MAP_MONOGRAPH_PART'
-        ,'ADMIN_SERIAL_ITEM'
     );
 
 -- stock Cataloging Administrator group
@@ -101,7 +100,6 @@ INSERT INTO permission.grp_perm_map ( grp, perm, depth, grantable )
     FROM permission.perm_list
     WHERE code in (
         'MAP_MONOGRAPH_PART'
-        ,'ADMIN_SERIAL_ITEM'
         ,'CREATE_VOLUME_SUFFIX'
         ,'UPDATE_VOLUME_SUFFIX'
         ,'DELETE_VOLUME_SUFFIX'
@@ -122,7 +120,7 @@ INSERT INTO permission.grp_perm_map ( grp, perm, depth )
     SELECT
         11,
         id,
-        0
+        1
     FROM permission.perm_list
     WHERE code in (
         'ADMIN_SERIAL_ITEM'