NeonN
Neon•10mo ago
popular-magenta

Trying to grant access to public schema, failing to grant access to public schema

I want to use Neon for my Better Auth authentication, to do this I need my user to be able to write to the public schema
I've created a new user called inklud_website, and a DB called inklud_website

To grant permissions for my user I've ran
GRANT CREATE, CONNECT ON DATABASE "inklud_website" TO "inklud_website";
GRANT USAGE, CREATE ON SCHEMA public TO "inklud_website";
GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA public TO "inklud_website";
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT, INSERT, UPDATE, DELETE ON TABLES TO "inklud_website";
GRANT USAGE ON ALL SEQUENCES IN SCHEMA public TO "inklud_website";
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT USAGE ON SEQUENCES TO "inklud_website";

But I still get a error: permission denied for schema public when trying to run migrations for better auth, indicating that the user still dosen't have access to public schema 😭
any idea?
Was this page helpful?