Mercurial > ~dholland > hg > swallowtail > index.cgi
diff database/schema/version.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 | 68cc276ac118 |
children |
line wrap: on
line diff
--- a/database/schema/version.sql Sun Apr 10 17:41:24 2022 -0400 +++ b/database/schema/version.sql Sun Apr 10 19:36:29 2022 -0400 @@ -11,3 +11,9 @@ version int not null ) WITHOUT OIDS; + +-- This is readonly except for system updates. +GRANT SELECT ON schemainfo TO swallowtail_admin; +GRANT SELECT ON schemainfo TO swallowtail_writer; +GRANT SELECT ON schemainfo TO swallowtail_reader; +GRANT SELECT ON schemainfo TO swallowtail_public;