Mercurial > ~dholland > hg > swallowtail > index.cgi
comparison database/schema/admin.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 | 36d91dfe017f |
children |
comparison
equal
deleted
inserted
replaced
54:36d91dfe017f | 55:40f64a96481f |
---|---|
31 type text not null references adminmailtypes, | 31 type text not null references adminmailtypes, |
32 pr bigint null references PRs, | 32 pr bigint null references PRs, |
33 userid bigint null references users | 33 userid bigint null references users |
34 ) | 34 ) |
35 WITHOUT OIDS; | 35 WITHOUT OIDS; |
36 | |
37 -- adminmailtypes is fixed | |
38 -- adminmailqueue is append-only except to admins | |
39 GRANT SELECT, INSERT, UPDATE, DELETE ON adminmailqueue TO swallowtail_admin; | |
40 GRANT INSERT ON attachments TO swallowtail_writer; |