N
Neon•6mo ago
rare-sapphire

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";
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?
0 Replies
No replies yetBe the first to reply to this messageJoin

Did you find this page helpful?