view database/init/users.sql @ 49:4b7f0ee35994

Use != in python and <> in sql.
author David A. Holland
date Sat, 02 Apr 2022 18:10:30 -0400
parents 90ec9e3b0a6f
children 40f64a96481f
line wrap: on
line source

-- Database user initialization.
-- Needs to be done as database superuser.
--
-- The users:
--    swallowtail_admin: owns the database tables
--    swallowtail_writer: has write access
--    swallowtail: has readonly access to everything
--    swallowtail_public: cannot see confidential PRs
--

create user swallowtail_admin;
create user swallowtail_writer;
create user swallowtail;
create user swallowtail_public;