supautils
supautils copied to clipboard
PostgreSQL extension that secures a cluster on a cloud environment
https://github.com/supabase/supautils/pull/61 but without refactors
## Problem Found an user doing the following for an API role: ```sql alter role service_role set statement_timeout = '15min'; ``` Which makes no sense because the API roles should...
## Problem Currently gives an error: ```sql alter role authenticator connection limit 30; ERROR: 42501: "authenticator" is a reserved role, only superusers can modify it ``` This is useful for...
WIP. Towards solving #79.
## Problem On pg 15 and lower https://www.postgresql.org/docs/15/sql-createrole.html > You must be a superuser to create a new role having the BYPASSRLS attribute. For pg 16 and up https://www.postgresql.org/docs/16/sql-createrole.html >...
## Problem Right now the different modules logic are tangled per statement and the standard hook (`run_process_utility_hook`) is scattered everywhere. This makes it hard to: - maintain the code and...
# Bug report - I confirm this is a bug with Supabase, not with my own application. - I confirm I have searched the [Docs](https://docs.supabase.com), GitHub [Discussions](https://github.com/supabase/supabase/discussions), and [Discord](https://discord.supabase.com). ##...
# Feature request A [user](https://app.hubspot.com/live-messages/19953346/inbox/6296356639#email) is requesting the ability to `create operator class` and `create operator family` so they can bring a bit of a DSL-y experience to their project...
It is currently possible for the `postgres` role to drop `information_schema` which breaks Supabase Studio and other IDE/developer tooling that relies on introspection. ```sql drop schema information_schema cascade; ``` This...
It is currently possible to drop `plpgsql` with ``` drop language plpgsql cascade; ``` which will breaks a lot of supabase functionality and is difficult to recover from ``` ERROR:...