/*
 * PostGres SQL DDL .
 *
 * Before using this file to create config tables, you must change hostname, 
 * username, password to the real name.
 * Under the directory containing this file, use this command to create the database:
 * su postgres -c "psql -q -f CREATE_USERS_POSTGRES.sql"
 */

-- Alarm user who can write to the tables from BEAST
CREATE USER alarm WITH PASSWORD 'pbar938';

-- Log user for JMS 2 RDB logging
CREATE USER log WITH PASSWORD 'psi3880';

-- Archive user who can write to the tables from BEAUTY
CREATE USER archive WITH PASSWORD 'eta1405';

-- Read-only user for reports
CREATE USER report WITH PASSWORD 'pass';

SELECT * FROM pg_user;
