3 SELECT evergreen.upgrade_deps_block_check('1050', :eg_version); -- mmorgan/cesardv/gmcharlt
5 CREATE OR REPLACE FUNCTION permission.usr_perms ( INT ) RETURNS SETOF permission.usr_perm_map AS $$
6 SELECT DISTINCT ON (usr,perm) *
8 (SELECT * FROM permission.usr_perm_map WHERE usr = $1)
10 (SELECT -p.id, $1 AS usr, p.perm, p.depth, p.grantable
11 FROM permission.grp_perm_map p
13 SELECT (permission.grp_ancestors(
14 (SELECT profile FROM actor.usr WHERE id = $1)
19 (SELECT -p.id, $1 AS usr, p.perm, p.depth, p.grantable
20 FROM permission.grp_perm_map p
21 WHERE p.grp IN (SELECT (permission.grp_ancestors(m.grp)).id FROM permission.usr_grp_map m WHERE usr = $1))
23 ORDER BY 2, 3, 4 ASC, 5 DESC ;
24 $$ LANGUAGE SQL STABLE ROWS 10;