supabase-postgres.git / summary / log / commit / refs

commit    8d73a7dddf13c629007f552ca30a7b71b412ff79
Author:   Bobbie Soedirgo <bobbie@soedirgo.dev>
Date:     Mon Apr 01 08:07:54 2024 +0000

    feat: dblink extension custom script


 .../dblink/after-create.sql                                | 14 ++++++++++++++
 1 file changed, 14 insertions(+)

diff --git a/ansible/files/postgresql_extension_custom_scripts/dblink/after-create.sql b/ansible/files/postgresql_extension_custom_scripts/dblink/after-create.sql
new file mode 100644
index 00000000..22261bc7
--- /dev/null
+++ 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
+$$;


[parent: 3688dd578c08]