Mercurial > ~dholland > hg > swallowtail > index.cgi
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; |