sql/functions/auth.delete_role_groups_for_user.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

drop function auth.delete_role_groups_for_user (
    p_user_id bigint
);

create or replace function auth.delete_role_groups_for_user (
    p_user_id bigint
)
returns void
as $$
begin
    delete from auth.users_role_groups urg
    where user_id = p_user_id;

    return;
end;
$$ language plpgsql;