comparison database/init/users.sql @ 30:90ec9e3b0a6f

add more users
author David A. Holland
date Mon, 27 May 2013 23:15:31 -0400
parents 000519947282
children 40f64a96481f
comparison
equal deleted inserted replaced
29:cd36b49f4437 30:90ec9e3b0a6f
1 -- Database user initialization. 1 -- Database user initialization.
2 -- Needs to be done as database superuser. 2 -- Needs to be done as database superuser.
3 -- 3 --
4 -- The 'swallowtail' user will have ordinary access to the database; 4 -- The users:
5 -- the 'swallowtail-admin' user will have full access to the database. 5 -- swallowtail_admin: owns the database tables
6 -- swallowtail_writer: has write access
7 -- swallowtail: has readonly access to everything
8 -- swallowtail_public: cannot see confidential PRs
9 --
6 10
11 create user swallowtail_admin;
12 create user swallowtail_writer;
7 create user swallowtail; 13 create user swallowtail;
8 create user swallowtail_admin; 14 create user swallowtail_public;