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