Security advisor complaining about "supabase-dbdev" in public schema
Hi there, I'm seeing the following warning in Security Advisor:
I've attempted the following with no luck:
As I receive the following error:
Any ideas?
Extension in Public
security
Entity
public.supabase-dbdev
Issue
Extension supabase-dbdev is installed in the public schema. Move it to another schema.
Description
Detects extensions installed in the public schema.I've attempted the following with no luck:
-- First, create the extensions schema if it doesn't exist
CREATE SCHEMA IF NOT EXISTS extensions;
-- Move the extension to the extensions schema
ALTER EXTENSION "supabase-dbdev" SET SCHEMA extensions;
As I receive the following error:
ERROR: 42501: must be owner of extension supabase-dbdevAny ideas?
