authen
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_reset_user_permissions
Parameters
Name
Type
Mode
user_id
integer
IN
prop_id
integer
IN (DEFAULT NULL)
Definition
declare v_group_id int; granted_count int; BEGIN v_group_id := (select user_group_id from users u where u.id = $1); delete from user_permission p where p.user_id = $1 and ($2 is null or p.prop_id = $2); insert into user_permission(user_id, prop_id, code) select distinct $1, usp.prop_id, code from user_property usp, group_permission gp where gp.group_id = v_group_id and usp.user_id = $1 and ($2 is null or usp.prop_id = $2) on conflict do nothing; GET DIAGNOSTICS granted_count = ROW_COUNT; RETURN granted_count; END