New tables don't get permissions of read-only users
We've added a bunch of tables recently that don't appear to have the same access for read-only users. Using \z you can see the projects table has these permissions:
public | projects | table | gitlab=arwdDxt/gitlab +| |
| | | postgres_exporter=r/gitlab +| |
| | | readonly=r/gitlab +| |
| | | gitlab_geo_fdw=r/gitlab | |
But new tables such as project_repository_states don't have this:
public | project_repository_states | table | | |
public | project_repository_states_id_seq | sequence | | |
I'm wondering if:
- We need to add some configuration in PostgreSQL to make these tables inherit these values.
- If not, do we need to grant privileges to each of the users via omnibus or Chef periodically
/cc: @_stark