From 6a3f290548a9d6b7fa48e9c56ff5bfbc33dfdd02 Mon Sep 17 00:00:00 2001 From: miker Date: Fri, 24 Oct 2008 18:21:44 +0000 Subject: [PATCH] give users with STAFF_LOGIN perm a work_ou of their home_ou (unless they have it already) git-svn-id: svn://svn.open-ils.org/ILS/branches/rel_1_4@10901 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/1.2.3-1.4-upgrade-db.sql | 8 ++++++++ 1 file changed, 8 insertions(+) diff --git a/Open-ILS/src/sql/Pg/1.2.3-1.4-upgrade-db.sql b/Open-ILS/src/sql/Pg/1.2.3-1.4-upgrade-db.sql index 4ee20df1f6..18f487472f 100644 --- a/Open-ILS/src/sql/Pg/1.2.3-1.4-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/1.2.3-1.4-upgrade-db.sql @@ -275,6 +275,14 @@ CREATE OR REPLACE FUNCTION permission.usr_has_object_perm ( INT, TEXT, TEXT, TEX SELECT permission.usr_has_object_perm( $1, $2, $3, $4, -1 ); $$ LANGUAGE SQL; +INSERT INTO permission.usr_work_ou_map (usr, work_ou) + SELECT u.id, + u.home_ou + FROM actor.usr u + LEFT JOIN permission.usr_work_ou_map m ON (u.id = m.usr AND u.home_ou = m.work_ou) + WHERE m.id IS NULL AND + permission.usr_has_perm(u.id,'STAFF_LOGIN',u.home_ou); + /* Enable LIKE to use an index for database clusters with locales other than C or POSIX */ CREATE INDEX authority_full_rec_value_tpo_index ON authority.full_rec (value text_pattern_ops); -- 2.11.0