From 1730a0fd3847eaa1fb736a2becefe4485678e8c7 Mon Sep 17 00:00:00 2001 From: Michele Morgan Date: Mon, 25 Jan 2016 12:05:27 -0500 Subject: [PATCH] lp1480432 - Changes function permission.usr_perms() to order by descending permission depth. This assures that users will get the most permissive depth per permission. Signed-off-by: Michele Morgan --- Open-ILS/src/sql/Pg/006.schema.permissions.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/006.schema.permissions.sql b/Open-ILS/src/sql/Pg/006.schema.permissions.sql index 27d5a428c3..72f6ca193a 100644 --- a/Open-ILS/src/sql/Pg/006.schema.permissions.sql +++ b/Open-ILS/src/sql/Pg/006.schema.permissions.sql @@ -140,7 +140,7 @@ CREATE OR REPLACE FUNCTION permission.usr_perms ( INT ) RETURNS SETOF permission FROM permission.grp_perm_map p WHERE p.grp IN (SELECT (permission.grp_ancestors(m.grp)).id FROM permission.usr_grp_map m WHERE usr = $1)) ) AS x - ORDER BY 2, 3, 1 DESC, 5 DESC ; + ORDER BY 2, 3, 4 ASC, 5 DESC ; $$ LANGUAGE SQL STABLE ROWS 10; CREATE TABLE permission.usr_work_ou_map ( -- 2.11.0