Create reusable script for enabling read-only database user

[MikeTheCanuck]

This procedure seems to be working well enough now:
https://github.com/hackoregon/civic-devops/blob/master/docs/HOWTO-enable-readonly-database-user.md

And I'm going to have to re-run it every time I "restore" (aka DROP and CREATE) a database, which is time-consuming, tedious and makes me wonder if I've ever fat-fingered something (e.g #152 ).

It would be awesome to have a reusable script - I'd be happy with with either something I can run from psql or something from the SQL interface of PGAdmin.

[nam20485]

There is a script in the backend repos under postgis_scripts, called 1_dbmake_user.sh. Ed made it, and borrowed it from his pet-containers repo to put in ours. That may or may not have some useful information. @znmeb

…

On Sun, Jun 3, 2018, 7:29 PM Mike Lonergan ***@***.***> wrote: This procedure seems to be working well enough now: https://github.com/hackoregon/civic-devops/blob/master/docs/HOWTO-enable-readonly-database-user.md And I'm going to have to re-run it every time I "restore" (aka DROP and CREATE) a database, which is time-consuming, tedious and makes me wonder if I've ever fat-fingered something (e.g #152 <#152> ). It would be awesome to have a reusable script - I'd be happy with with either something I can run from psql or something from the SQL interface of *PGAdmin*. — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#155>, or mute the thread <https://github.com/notifications/unsubscribe-auth/ABvqFPzzx7MFyzNKy6J_VUS0mhBSptYxks5t5JuagaJpZM4UYXQY> .

[MikeTheCanuck]

I've assembled the bones of a working model here:
#159

Untested so far, and is a brute-force method rather than anything reasonably elegant.

Remember: "working" first, then "good", and maybe later "fast".