Mercurial > ~dholland > hg > swallowtail > index.cgi
comparison database/schema/logs.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 | cd36b49f4437 |
children |
comparison
equal
deleted
inserted
replaced
54:36d91dfe017f | 55:40f64a96481f |
---|---|
9 | 9 |
10 -- if a message was posted, this is the one | 10 -- if a message was posted, this is the one |
11 msgid bigint null references messages (id) | 11 msgid bigint null references messages (id) |
12 ) | 12 ) |
13 WITHOUT OIDS; | 13 WITHOUT OIDS; |
14 | |
15 -- We don't ordinarily edit or delete log entries. If you really need | |
16 -- to do that for some reason (e.g. mispasted passwords) log in as | |
17 -- swallowtail_owner. | |
18 GRANT SELECT, INSERT ON adminlog TO swallowtail_admin; | |
19 GRANT SELECT, INSERT ON adminlog TO swallowtail_writer; | |
20 GRANT SELECT ON adminlog TO swallowtail_reader; | |
21 GRANT SELECT ON adminlog TO swallowtail_public; |