I am running into some strange error when I upgraded my app to rails version 6 and pushed to heroku that is connected to Amazon RDS.

Seungyong Lim asked October 23, 2021 1:20am in Databases

Seungyong Lim October 23, 2021 1:20am

I am getting the following error: ActiveRecord::StatementInvalid (PG::InsufficientPrivilege: ERROR: permission denied for relation users.. It is definitely a role issue but I am not sure what could be causing it and how to fix.
when running heroku run rails console --app finders-staging and tried update a User record, and I get the same error:
ActiveRecord::StatementInvalid (PG::InsufficientPrivilege: ERROR: permission denied for relation users).
Any help/suggestion would be appreciated!

Join the discussion

Create an account Log in

Courses

Rails for Beginners

Advanced Ruby: Behind the Magic

Payments with Rails Master Class

Refactoring Rails

Apps

Hatchbox.io

Jumpstart Rails SaaS Template

Other

Remote Ruby Podcast

GoRails Open Source

Rails Hackathon

Beginner Bounties

Ruby on Rails Job Board

Notifications

I am running into some strange error when I upgraded my app to rails version 6 and pushed to heroku that is connected to Amazon RDS.

Want to stay up-to-date with Ruby on Rails?