From 469e198f32a6b46627a696ff3f60c86ef4a0113f Mon Sep 17 00:00:00 2001 From: miker Date: Mon, 13 Feb 2006 20:04:29 +0000 Subject: [PATCH] fixing perm lookup bug git-svn-id: svn://svn.open-ils.org/ILS/trunk@3044 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/006.schema.permissions.sql | 7 ++++++- 1 file changed, 6 insertions(+), 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 4fee24f105..a7ab679f20 100644 --- a/Open-ILS/src/sql/Pg/006.schema.permissions.sql +++ b/Open-ILS/src/sql/Pg/006.schema.permissions.sql @@ -149,7 +149,12 @@ CREATE OR REPLACE FUNCTION permission.usr_perms ( INT ) RETURNS SETOF permission UNION ALL (SELECT -p.id, $1 AS usr, p.perm, p.depth, p.grantable FROM permission.grp_perm_map p - WHERE p.grp = (SELECT profile FROM actor.usr WHERE id = $1 LIMIT 1)) + WHERE p.grp IN ( + SELECT (permission.grp_ancestors( + (SELECT profile FROM actor.usr WHERE id = $1) + )).id + ) + ) UNION ALL (SELECT -p.id, $1 AS usr, p.perm, p.depth, p.grantable FROM permission.grp_perm_map p -- 2.43.2