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:

Example Command to create a database

Create database i2b2demodata

3. Create the following users:

CREATE USER i2b2demodata WITH PASSWORD 'myPassword';

Grant all the privileges on the database

GRANT ALL PRIVILEGES ON DATABASE i2b2demodata to i2b2demodata;

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

Example: For the i2b2demodata database you will grant all access to the i2b2demodata user.