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 |
|---|
|
Example Command to create a database |
| indent |
|---|
|
| Panel |
|---|
| borderColor | #ccc |
|---|
| bgColor | #ffffff |
|---|
| titleBGColor | #DDD9C3 |
|---|
| borderStyle | solid |
|---|
| title | Create Database Command |
|---|
| Create database i2b2 |
|
| indent |
|---|
|
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 Schema's 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; |
| Note |
|---|
|
| indent |
|---|
| Make sure you grant all privileges on all tables in the database to the appropriate user. |
| indent |
|---|
| Example: For the i2b2 database you will grant all access to the i2b2demodata user. 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;
|
|
