comparison 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
comparison
equal deleted inserted replaced
54:36d91dfe017f 55:40f64a96481f
66 closed boolean not null, 66 closed boolean not null,
67 nagresponsible boolean not null, 67 nagresponsible boolean not null,
68 nagsubmitter boolean not null, 68 nagsubmitter boolean not null,
69 timeout boolean not null 69 timeout boolean not null
70 ) WITHOUT OIDS; 70 ) WITHOUT OIDS;
71
72 -- These are readonly for all routine operations.
73 GRANT SELECT ON states TO swallowtail_admin;
74 GRANT SELECT ON states TO swallowtail_writer;
75 GRANT SELECT ON states TO swallowtail_reader;
76 GRANT SELECT ON states TO swallowtail_public;