changeset 30:90ec9e3b0a6f

add more users
author David A. Holland
date Mon, 27 May 2013 23:15:31 -0400
parents cd36b49f4437
children 12a4c9f88510
files database/init/users.sql
diffstat 1 files changed, 9 insertions(+), 3 deletions(-) [+]
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;