Steps to Create i2b2 Database Users
The following outlines the steps to take when creating the user accounts in your PostgreSQL database.
indent |
---|
|
1. Log into PostgreSQL using psql. $ su - postgres $ psql |
indent |
---|
|
2. Create the following databases: |
indent |
---|
|
Database |
---|
i2b2demodata | i2b2hive | i2b2imdata | i2b2metadata | i2b2pm | i2b2workdata |
|
indent |
---|
|
Example Command to create a database |
indent |
---|
|
Panel |
---|
borderColor | #ccc |
---|
bgColor | #ffffff |
---|
titleBGColor | #DDD9C3 |
---|
borderStyle | solid |
---|
title | Create Database Command |
---|
| Create database i2b2demodata |
|
indent |
---|
|
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; |
indent |
---|
|
User Name | Password | Database |
---|
i2b2demodata | demouser | i2b2demodata | i2b2hive | demouser | i2b2hive | i2b2imdata | demouser | i2b2imdata | i2b2metadata | demouser | i2b2metadata | i2b2pm | demouser | i2b2pm | i2b2workdata | demouser | i2b2workdata |
|
Note |
---|
|
indent |
---|
| Make sure you grant all privileges on all tables in the database to the appropriate user. |
indent |
---|
| Example: For the i2b2demodata database you will grant all access to the i2b2demodata user. |
|