comparison database/schema/bugs.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 36d91dfe017f
children
comparison
equal deleted inserted replaced
54:36d91dfe017f 55:40f64a96481f
72 --fix text , 72 --fix text ,
73 --unformatted text 73 --unformatted text
74 74
75 ) 75 )
76 WITHOUT OIDS; 76 WITHOUT OIDS;
77
78 -- Only the admin can delete PRs.
79 GRANT SELECT, INSERT, UPDATE, DELETE ON PRs TO swallowtail_admin;
80 GRANT SELECT, INSERT, UPDATE ON PRs TO swallowtail_writer;
81 GRANT SELECT ON PRs TO swallowtail_reader;
82 GRANT SELECT ON PRs TO swallowtail_public;