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;