authen
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
fn_role_effective_perm_ids
Parameters
Name
Type
Mode
group_id
integer
IN
prop_id
integer
IN
Definition
SELECT perm_id FROM ( SELECT gp.perm_id FROM public.group_permission gp WHERE gp.group_id = fn_role_effective_perm_ids.group_id UNION SELECT gpo.perm_id FROM public.group_permission_override gpo WHERE gpo.group_id = fn_role_effective_perm_ids.group_id AND gpo.prop_id = fn_role_effective_perm_ids.prop_id AND gpo.action_type = 'allow' ) allowed WHERE NOT EXISTS ( SELECT 1 FROM public.group_permission_override d WHERE d.group_id = fn_role_effective_perm_ids.group_id AND d.prop_id = fn_role_effective_perm_ids.prop_id AND d.action_type = 'deny' AND d.perm_id = allowed.perm_id )