diff 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
line wrap: on
line diff
--- a/database/init/users.sql	Sun May 26 23:24:45 2013 -0400
+++ b/database/init/users.sql	Mon May 27 23:15:31 2013 -0400
@@ -1,8 +1,14 @@
 -- Database user initialization.
 -- Needs to be done as database superuser.
 --
--- The 'swallowtail' user will have ordinary access to the database;
--- the 'swallowtail-admin' user will have full access to the database.
+-- 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_admin;
+create user swallowtail_public;