Alter default privileges on public schema to data group

CityOfLosAngeles / aqueduct

A shared pipeline for building ETLs and batch jobs that we run at the City of LA for Data Science Projects. Built on Apache Airflow & Civis Platform

Apache License 2.0

21 stars 6 forks source link

Alter default privileges on public schema to data group #353

Closed ian-r-rose closed 4 years ago

ian-r-rose commented 4 years ago

We'd like to ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES to ita_data so that, at the very least, all public tables can be queried by the data group. We should probably do the same for other roles (e.g. mayor's office group)

ian-r-rose commented 4 years ago

I would do this now, but lack permissions on public to alter the permissions.

ian-r-rose commented 4 years ago

This is now done. All tables created in the public schema by the robot user are accessible by ita-data by default