Postgres User Permissions For Prisma


#1

I created a Postgres RDS instance on AWS. An admin user is automatically created for you, when I use that in conjunction with the one click heroku prisma app it works fine. However, when I create a new user that I want to use prisma with, it does not work. I am however able to manually login with that user and query tables. Here is how I created the user in postgres:

CREATE ROLE services_role;
GRANT USAGE ON SCHEMA “default$default” TO services_role;
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA “default$default” TO services_role;
GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA “default$default” TO services_role;
create user test with encrypted password ‘test’;
GRANT services_role TO test;

I get this error with the user test:

Exception in thread “main” org.postgresql.util.PSQLException: ERROR: permission denied for database prisma.

I can manually connect to that database through psql with that user however.


#2

#3

This topic was automatically closed 45 days after the last reply. New replies are no longer allowed.