Create and configure read-only RDS user for Grafana integration

[elipe17]

Background

To support OFA's data access needs via PLG we need to create a read only user in all of our RDS Postgress databases. This user would then be connected to our Grafana datasource which would prevent Grafana users from deleting/modifying data as they try to create dashboards or export the data.

Acceptance Criteria

• Postgres datasource is connected to read only RDS user
• Read only style queries are the only style of queries that can be run via Grafana
• Old Postgres datasource is removed
• Testing Checklist has been run and all tests pass
• README is updated, if necessary

Tasks

• Add read only RDS Postgres user to all databases
• Update Grafana to leverage new user in Postgres datasource
• Run Testing Checklist and confirm all tests pass

Notes

Aws provides a guideline fro creating readonly users/roles

• https://aws.amazon.com/blogs/database/managing-postgresql-users-and-roles/