© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•7mo ago•
7 replies
cjones26

Security advisor complaining about "supabase-dbdev" in public schema

Hi there, I'm seeing the following warning in Security Advisor:

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.
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;
-- 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-dbdev
ERROR:  42501: must be owner of extension supabase-dbdev


Any ideas?
Supabase banner
SupabaseJoin
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
45,816Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

Security Advisor (upgrading database)
SupabaseSSupabase / help-and-questions
5mo ago
Security advisor is confusing?
SupabaseSSupabase / help-and-questions
6mo ago
Using Supabase in NextJS - Security
SupabaseSSupabase / help-and-questions
2y ago
Supabase security bypass
SupabaseSSupabase / help-and-questions
13mo ago