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

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

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Use != in python and <> in sql.
author David A. Holland
date Sat, 02 Apr 2022 18:10:30 -0400
parents 90ec9e3b0a6f
children 40f64a96481f
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
8
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
1 -- Database user initialization.
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
2 -- Needs to be done as database superuser.
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
3 --
30
90ec9e3b0a6f add more users
David A. Holland
parents: 28
diff changeset
4 -- The users:
90ec9e3b0a6f add more users
David A. Holland
parents: 28
diff changeset
5 -- swallowtail_admin: owns the database tables
90ec9e3b0a6f add more users
David A. Holland
parents: 28
diff changeset
6 -- swallowtail_writer: has write access
90ec9e3b0a6f add more users
David A. Holland
parents: 28
diff changeset
7 -- swallowtail: has readonly access to everything
90ec9e3b0a6f add more users
David A. Holland
parents: 28
diff changeset
8 -- swallowtail_public: cannot see confidential PRs
90ec9e3b0a6f add more users
David A. Holland
parents: 28
diff changeset
9 --
8
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
10
30
90ec9e3b0a6f add more users
David A. Holland
parents: 28
diff changeset
11 create user swallowtail_admin;
90ec9e3b0a6f add more users
David A. Holland
parents: 28
diff changeset
12 create user swallowtail_writer;
8
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
13 create user swallowtail;
30
90ec9e3b0a6f add more users
David A. Holland
parents: 28
diff changeset
14 create user swallowtail_public;