Steps to Create i2b2 Database Users #
The following outlines the steps to take when creating the user accounts in your PostgreSQL database.
1. Log into PostgreSQL using psql.
$ su – postgres
$ psql
|
Database |
|---|
|
i2b2 |
Create database i2b2
3. Create the following users:
CREATE USER i2b2demodata WITH PASSWORD ‘demouser’ ;
CREATE USER i2b2hive WITH PASSWORD ‘demouser’ ;
CREATE USER i2b2imdata WITH PASSWORD ‘demouser’ ;
CREATE USER i2b2metadata WITH PASSWORD ‘demouser’ ;
CREATE USER i2b2pm WITH PASSWORD ‘demouser’ ;
CREATE USER i2b2workdata WITH PASSWORD ‘demouser’ ;
Create the Schema’s
CREATE SCHEMA i2b2demodata AUTHORIZATION i2b2demodata ;
CREATE SCHEMA i2b2hive AUTHORIZATION i2b2hive ;
CREATE SCHEMA i2b2imdata AUTHORIZATION i2b2imdata;
CREATE SCHEMA i2b2metadata AUTHORIZATION i2b2metadata ;
CREATE SCHEMA i2b2pm AUTHORIZATION i2b2pm ;
CREATE SCHEMA i2b2workdata AUTHORIZATION i2b2workdata;
Important
Example: For the i2b2 database you will grant all access to the i2b2demodata user.
GRANT ALL PRIVILEGES ON DATABASE i2b2 to i2b2demodata;
GRANT ALL PRIVILEGES ON DATABASE i2b2 to i2b2hive;
GRANT ALL PRIVILEGES ON DATABASE i2b2 to i2b2imdata;
GRANT ALL PRIVILEGES ON DATABASE i2b2 to i2b2metadata;
GRANT ALL PRIVILEGES ON DATABASE i2b2 to i2b2pm;
GRANT ALL PRIVILEGES ON DATABASE i2b2 to i2b2workdata;
GRANT ALL PRIVILEGES ON DATABASE i2b2 to i2b2demodata;
