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

comparison database/schema/subscription.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
comparison
equal deleted inserted replaced
54:36d91dfe017f 55:40f64a96481f
40 -- AND subscriptions.responsible 40 -- AND subscriptions.responsible
41 -- AND NOT users.oldresponsible 41 -- AND NOT users.oldresponsible
42 -- ; 42 -- ;
43 -- 43 --
44 -- should always return nothing. 44 -- should always return nothing.
45
46 -- Generically accessible.
47 GRANT SELECT, INSERT, UPDATE, DELETE ON subscriptions TO swallowtail_admin;
48 GRANT SELECT, INSERT, UPDATE, DELETE ON subscriptions TO swallowtail_writer;
49 GRANT SELECT ON subscriptions TO swallowtail_reader;
50 GRANT SELECT ON subscriptions TO swallowtail_public;