From 08e435104c42751689553537b1f20ffb14b8dfcc Mon Sep 17 00:00:00 2001
From: ckonstanski <kostcarl@isu.edu>
Date: Sat, 18 Jul 2026 21:18:18 -0600
Subject: initial commit

---
 sql/functions/auth.delete_role_groups_for_user.sql | 16 ++++++++++++++++
 1 file changed, 16 insertions(+)
 create mode 100644 sql/functions/auth.delete_role_groups_for_user.sql

(limited to 'sql/functions/auth.delete_role_groups_for_user.sql')

diff --git a/sql/functions/auth.delete_role_groups_for_user.sql b/sql/functions/auth.delete_role_groups_for_user.sql
new file mode 100644
index 0000000..1b14f0d
--- /dev/null
+++ b/sql/functions/auth.delete_role_groups_for_user.sql
@@ -0,0 +1,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;
-- 
cgit v1.3