Mercurial > ~dholland > hg > swallowtail > index.cgi
comparison 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 |
comparison
equal
deleted
inserted
replaced
54:36d91dfe017f | 55:40f64a96481f |
---|---|
9 -- Should have only one row. | 9 -- Should have only one row. |
10 CREATE TABLE schemainfo ( | 10 CREATE TABLE schemainfo ( |
11 version int not null | 11 version int not null |
12 ) | 12 ) |
13 WITHOUT OIDS; | 13 WITHOUT OIDS; |
14 | |
15 -- This is readonly except for system updates. | |
16 GRANT SELECT ON schemainfo TO swallowtail_admin; | |
17 GRANT SELECT ON schemainfo TO swallowtail_writer; | |
18 GRANT SELECT ON schemainfo TO swallowtail_reader; | |
19 GRANT SELECT ON schemainfo TO swallowtail_public; |