Mercurial > ~dholland > hg > swallowtail > index.cgi
diff database/schema/config.sql @ 55:40f64a96481f
Adjust database user arrangements and grant schema privs.
author | David A. Holland |
---|---|
date | Sun, 10 Apr 2022 19:36:29 -0400 |
parents | 45bb7b516edb |
children |
line wrap: on
line diff
--- a/database/schema/config.sql Sun Apr 10 17:41:24 2022 -0400 +++ b/database/schema/config.sql Sun Apr 10 19:36:29 2022 -0400 @@ -68,3 +68,9 @@ nagsubmitter boolean not null, timeout boolean not null ) WITHOUT OIDS; + +-- These are readonly for all routine operations. +GRANT SELECT ON states TO swallowtail_admin; +GRANT SELECT ON states TO swallowtail_writer; +GRANT SELECT ON states TO swallowtail_reader; +GRANT SELECT ON states TO swallowtail_public;