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;