Mercurial > ~dholland > hg > swallowtail > index.cgi

diff database/schema/admin.sql @ 55:40f64a96481f

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Adjust database user arrangements and grant schema privs.
author David A. Holland
date Sun, 10 Apr 2022 19:36:29 -0400
parents 36d91dfe017f
children
line wrap: on
line diff
--- a/database/schema/admin.sql	Sun Apr 10 17:41:24 2022 -0400
+++ b/database/schema/admin.sql	Sun Apr 10 19:36:29 2022 -0400
@@ -33,3 +33,8 @@
 	userid bigint		null references users
 )
 WITHOUT OIDS;
+
+-- adminmailtypes is fixed
+-- adminmailqueue is append-only except to admins
+GRANT SELECT, INSERT, UPDATE, DELETE ON adminmailqueue TO swallowtail_admin;
+GRANT INSERT ON attachments TO swallowtail_writer;