All threads / 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.
Ask A Question

Notifications

You’re not receiving notifications from this thread.

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 in Databases

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

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

Join 70,078+ developers who get early access to new tutorials, screencasts, articles, and more.

    We care about the protection of your data. Read our Privacy Policy.

    logo Created with Sketch.

    Screencast tutorials to help you learn Ruby on Rails, Javascript, Hotwire, Turbo, Stimulus.js, PostgreSQL, MySQL, Ubuntu, and more. Icons by Icons8

    © 2023 GoRails, LLC. All rights reserved.