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

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?