authen
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
fn_role_reset_permissions
Parameters
Name
Type
Mode
v_group_id
integer
IN
v_prop_id
integer
IN
v_clear_overrides
boolean
IN (DEFAULT true)
Definition
BEGIN IF v_clear_overrides THEN DELETE FROM public.group_permission_override WHERE group_id = v_group_id AND prop_id = v_prop_id; END IF; PERFORM public.sp_reset_user_permissions(ur.user_id, ur.prop_id) FROM public.user_roles ur WHERE ur.group_id = v_group_id AND ur.prop_id = v_prop_id AND ur.active; END