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!

Reply
Join the discussion
Create an account Log in

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

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

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

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

    © 2023 GoRails, LLC. All rights reserved.