feat: dblink extension custom script

soedirgo · soedirgo · commit 8d73a7dddf13 · 2024-04-04T16:20:55.000+08:00
diff --git a/ansible/files/postgresql_extension_custom_scripts/dblink/after-create.sql b/ansible/files/postgresql_extension_custom_scripts/dblink/after-create.sql
@@ -0,0 +1,14 @@
+do $$
+declare
+  r record;
+begin
+  for r in (select oid, (aclexplode(proacl)).grantee from pg_proc where proname = 'dblink_connect_u') loop
+   continue when r.grantee = 'supabase_admin'::regrole;
+   execute(
+     format(
+       'revoke all on function %s(%s) from %s;', r.oid::regproc, pg_get_function_identity_arguments(r.oid), r.grantee::regrole
+     )
+   );
+  end loop;
+end
+$$;
