Dev Env Leaderboard Post Call Permission Denied

[tyleryy]

Overview

POST API call to {hostname}/leaderboard/ in dev environment returns a server error: error: permission denied for sequence leaderboard_id_seq. This error occurs using AWS personal user creds, but not AWS prod creds.

Cause

I think there is some permission error in our AWS Postgres instance preventing api calls from localhost:3001 from going through to our database. This is why the error appears in dev but not prod.

Steps to Replicate

1. Open Dev Environment frontend and backend (with AWS personal user credentials)
2. Check console (API call is made immediately on page load in a useEffect)
3. See error

Frontend: zotnfound-frontend/src/components/Home/Home.jsx (Leaderboard GetInfo UseEffect)
Backend: zotnfound-backend/routes/leaderboard.js/ (POST call from await pool.query(...))

** Update ** - I believe this is happening to all API calls to Postgres Instance