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.
Username |
Password |
Database / Schema |
|
i2b2demodata |
demouser |
i2b2demodata |
|
i2b2hive |
demouser |
i2b2hive |
|
i2b2imdata |
demouser |
i2b2imdata |
|
i2b2metadata |
demouser |
i2b2metadata |
|
i2b2pm |
demouser |
i2b2pm |
|
i2b2workdata |
demouser |
i2b2workdata |
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.
- Open a browser and enter: http://yourhost:yourPort/apex
- Log in as system user.
- Click on Administration icon to open the Administration page.
- Click on Database Users icon to open the Manage Database Users page.
- Click on Create button to open the Create Database User page.
- In the Create Database User section enter the following user name and password:
User Name: i2b2metadata
Password: demouser
Warning |
When setting up the new users make sure Expire Password is NOT checked off. |
- In the User Privileges section check off the following options:
CREATE PROCEDURE |
CREATE ROLE |
CREATE SEQUENCE |
CREATE TABLE |
CREATE TRIGGER |
CREATE TYPE |
CREATE VIEW |
|
|
- Click on the Create button to save the user.
- Repeat steps 1-8 to create to create the following additional users:
User Name |
Password |
Project |
|
i2b2demodata |
demouser |
Demo |
|
i2b2hive |
demouser |
|
|
i2b2imdata |
demouser |
Demo |
|
i2b2pm |
demouser |
|
|
i2b2workdata |
demouser |
Demo |
|
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.
- Log into PostgreSQL using psql.
$ su - postgres
$ psql
- Create the following databases:
Database | |
i2b2 |
Example Command to create a database
Create Database Command
create database i2b2
- 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;
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; |
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.
- Log into SQL Server Management Studio
- Create the following databases
Database | |
i2b2demodata |
|
i2b2hive |
|
i2b2imdata |
|
i2b2metadata |
|
i2b2pm |
|
i2b2workdata |
- Create the following users <i>(new logins)</i>.
User Name |
Password |
Database |
|
i2b2demodata |
demouser |
i2b2demodata |
|
i2b2hive |
demouser |
i2b2hive |
|
i2b2imdata |
demouser |
i2b2imdata |
|
i2b2metadata |
demouser |
i2b2metadata |
|
i2b2pm |
demouser |
i2b2pm |
|
i2b2workdata |
demouser |
i2b2workdata |
Warning |
When setting up the new logins make sure Enforce password expiration is NOT checked off. |
Comments
0 comments
Please sign in to leave a comment.