Setup Roles, Passwords. #3

https://www.postgresql.org/docs/current/user-manag.html

The link above has background.
I'd like to create a

role that has select permissions but nothing else.
role that has insert permissions
a non-superuser to manage other parts of the database.

I've included a script in XXXX to initiate connections.

After setting up these roles, investigate adding them to the docker build steps.

https://www.postgresql.org/docs/current/user-manag.html The link above has background. I'd like to create a - [x] role that has select permissions but nothing else. - [x] role that has insert permissions - [x] a non-superuser to manage other parts of the database. I've included a script in XXXX to initiate connections. After setting up these roles, investigate adding them to the docker build steps.

list of roles to create:

root (should replace admin in postgres docker-compose with this.)
ctti (inherits from root) (can this be done without login?)
writer (used by data scraper)
analysis (used by those requesting data, is read only)

list of roles to create: - [x] root (should replace admin in postgres docker-compose with this.) - [x] ctti (inherits from root) (can this be done without login?) - [ ] writer (used by data scraper) - [x] analysis (used by those requesting data, is read only)

Done, before 9de976e

Done, before 9de976e

Labels Milestones

Setup Roles, Passwords. #3