Developers Getting Started With i2b2
Space shortcuts
Space Tools
Skip to end of metadata
Go to start of metadata

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

2. Create the following databases:

Database

i2b2


Example Command to create a database
Create Database Command

    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


Make sure you grant all privileges on all tables in the database to the appropriate user.

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;