PSQL command seems unable to manage database privileges

UW-Macrostrat / macrostrat

A geological data platform for exploration, integration, and analysis

Apache License 2.0

4 stars 1 forks source link

Open davenquinn opened 11 months ago

davenquinn commented 11 months ago

Running role-altering commands does not seem to work properly, and fails silently.

macrostrat db psql sgp -c "GRANT ALL ON ALL TABLES IN SCHEMA public TO macrostrat"

psql appears to run the GRANT statement, but the roles do not seem to have been applied to the database.

davenquinn commented 11 months ago

We should test this, potentially as part of moving the core functionality to shared Python libraries.