permission denied for schema public. 2 hours trying to solve it.
Hello everyona!
I'm working on an MVP and started integrating my backend with Supabase. However, after a lot of frustration, I decided to simplify things and ended up creating a file called
I’ve tested both the anon API key and the service API key, but in both cases I get a permission denied for schema public error. I’ve tried so many different things, but nothing has worked. The most informative error messages I’ve gotten are the following (the table name is messages, located at public.messages):
When I check the official troubleshooting page for this error: https://supabase.com/docs/guides/troubleshooting/database-api-42501-errors It shows this query:
Returns this error:
I assumed postgres_logs would be a pre-built table.
What can I do?
I'm working on an MVP and started integrating my backend with Supabase. However, after a lot of frustration, I decided to simplify things and ended up creating a file called
supabase_ping.pyI’ve tested both the anon API key and the service API key, but in both cases I get a permission denied for schema public error. I’ve tried so many different things, but nothing has worked. The most informative error messages I’ve gotten are the following (the table name is messages, located at public.messages):
WARN: Query to 'messages' failed. Table may not exist or permissions denied.
Exception: Error 42501:
Message: permission denied for schema publicWhen I check the official troubleshooting page for this error: https://supabase.com/docs/guides/troubleshooting/database-api-42501-errors It shows this query:
select
cast(postgres_logs.timestamp as datetime) as timestamp,
event_message,
parsed.error_severity,
parsed.user_name,
parsed.query,
parsed.detail,
parsed.hint
from
postgres_logs
cross join unnest(metadata) as metadata
cross join unnest(metadata.parsed) as parsed
where
regexp_contains(parsed.error_severity, 'ERROR|FATAL|PANIC')
and parsed.sql_state_code = '42501'
order by timestamp desc
limit 100;Returns this error:
ERROR: 42P01: relation "postgres_logs" does not exist
LINE 10: postgres_logsI assumed postgres_logs would be a pre-built table.
What can I do?
supabase_ping.py2.63KB
Supabase is the Postgres development platform providing all the backend features you need to build a product.
