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