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.