authen
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
fn_user_top_group
Parameters
Name
Type
Mode
v_user_id
integer
IN
Definition
SELECT ug.id FROM public.user_roles ur JOIN public.user_group ug ON ug.id = ur.group_id WHERE ur.user_id = v_user_id AND ur.active ORDER BY public.fn_group_type_rank(ug.group_type), ug.id LIMIT 1