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

diff database/schema/logs.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 cd36b49f4437
children
line wrap: on
line diff
--- a/database/schema/logs.sql	Sun Apr 10 17:41:24 2022 -0400
+++ b/database/schema/logs.sql	Sun Apr 10 19:36:29 2022 -0400
@@ -11,3 +11,11 @@
 	msgid bigint		null references messages (id)
 )
 WITHOUT OIDS;
+
+-- We don't ordinarily edit or delete log entries. If you really need
+-- to do that for some reason (e.g. mispasted passwords) log in as
+-- swallowtail_owner.
+GRANT SELECT, INSERT ON adminlog TO swallowtail_admin;
+GRANT SELECT, INSERT ON adminlog TO swallowtail_writer;
+GRANT SELECT ON adminlog TO swallowtail_reader;
+GRANT SELECT ON adminlog TO swallowtail_public;