When setting up the new users make sure Expire Password is NOT checked off.3.3 Create Database User Accounts

In order for the i2b2 database scripts to work and enable the core cells to communicate with the database you need to create user accounts in your i2b2 database. The following table shows what users will be created for each database / schema that is part of the i2b2 database.

The process of creating these users depends on which Database Management System you are using in your environment. Proceed to the section that correlates to your environment (Oracle, PostgreSQL or SQL Server).

3.3.1 Create User Accounts in Oracle

Steps to Create i2b2 Database Users

The following outlines the steps to take when creating the user accounts in your Oracle database.

1. Open a browser and enter: http://yourhost:yourPort/apex
2. Log in as system user.
3. Click on Administration icon to open the Administration page.

4. Click on Database Users icon to open the Manage Database Users page.

5. Click on Create button to open the Create Database User page.

6. In the Create Database User section enter the following user name and password:

User Name: i2b2metadata

Password: demouser

7. In the User Privileges section check off the following options:

8. Click on the Create button to save the user.
9. Repeat steps 1-8 to create to create the following additional users:

3.3.2 Create User Accounts in PostgreSQL

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 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 Schemas

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;

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;

3.3.3 Create User Accounts in SQL Server

Steps to Create i2b2 Database Users

The following outlines the steps to take when creating the user accounts in your SQL Server database.

1. Log into SQL Server Management Studio
2. Create the following databases

3. Create the following users <i>(new logins)</i>.