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 |
|---|
i2b2demodata |
i2b2hive |
i2b2imdata |
i2b2metadata |
i2b2pm |
i2b2workdata |
Example Command to create a database
Create Database Command
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;
User Name | Password | Database |
|---|---|---|
i2b2demodata | demouser | i2b2demodata |
i2b2hive | demouser | i2b2hive |
i2b2imdata | demouser | i2b2imdata |
i2b2metadata | demouser | i2b2metadata |
i2b2pm | demouser | i2b2pm |
i2b2workdata | demouser | i2b2workdata |
Important
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.
