Permission denied for schema citext

Forgive me as I am not very familiar with the database roles & schema security. I'm following the PostGIS instructions for the citext extension.

Here is what I did:

create schema if not exists "citext";
create extension citext with schema "citext";

create schema if not exists "citext";
create extension citext with schema "citext";

I'm getting this error:

PostgrestException(message: permission denied for schema citext, code: 42501, details: Forbidden, hint: null)

PostgrestException(message: permission denied for schema citext, code: 42501, details: Forbidden, hint: null)

How can I fix this in a secure way?

Supabase•15mo ago•

7 replies

dannyh

Permission denied for schema citext

Forgive me as I am not very familiar with the database roles & schema security. I'm following the PostGIS instructions for the citext extension.

Here is what I did:

create schema if not exists "citext";
create extension citext with schema "citext";

create schema if not exists "citext";
create extension citext with schema "citext";

I'm getting this error:

PostgrestException(message: permission denied for schema citext, code: 42501, details: Forbidden, hint: null)

PostgrestException(message: permission denied for schema citext, code: 42501, details: Forbidden, hint: null)

How can I fix this in a secure way?

Permission denied for schema citext

Similar Threads

Permission denied for schema citext

Similar Threads

Similar Threads

Similar Threads