Page History
The Adapter uses the SHRINE user to run queries on i2b2's CRC.
To set up the standard SHRINE application user, you will need to connect to the i2b2pm database and insert entries for this user (NB: the actual database name may be different from what is displayed here, but the essential element is that you should locate the tables below in the correct database and schema before proceeding):
| Code Block | ||||
|---|---|---|---|---|
| ||||
insert into PM_USER_DATA
(user_id, full_name, password, status_cd)
values
('shrine', 'SHRINE User', '9117d59a69dc49807671a51f10ab7f', 'A');
-- The password hash you see above is for 'demouser' . Use something else.
insert into PM_PROJECT_USER_ROLES
(PROJECT_ID, USER_ID, USER_ROLE_CD, STATUS_CD)
values
('SHRINE', 'shrine', 'USER', 'A');
insert into PM_PROJECT_USER_ROLES
(PROJECT_ID, USER_ID, USER_ROLE_CD, STATUS_CD)
values
('SHRINE', 'shrine', 'DATA_OBFSC', 'A');
|
...
Overview
Content Tools