Skip to main content

Setting up new user roles on the database

NOTE: You can only do this if you have permission to Heroku.

  1. Go to Heroku
  2. Access the production database (Standard 4). 2020-01-27_1053.png
  3. Go to the credential tab and create new credentials aaa.png
  4. Add a name and set permissions to read only bbb.png
  5. Run heroku run bash -a powr
  6. Run bundle exec rake automate:grant_db_permissions['limited_user'], where limited_user is the name you set back in step 4.
  7. Go back to heroku and find the follower db zzz.png
  8. Share creds zz.png