Chapter 8.1 - Setting up the QEP user

insert into PM_USER_DATA
(user_id, full_name, password, status_cd)
values
('qep', 'SHRINE QEP User', 'password', 'A');

insert into PM_PROJECT_USER_ROLES
(PROJECT_ID, USER_ID, USER_ROLE_CD, STATUS_CD)
values
('SHRINE', 'qep', 'USER', 'A');

insert into PM_PROJECT_USER_ROLES
(PROJECT_ID, USER_ID, USER_ROLE_CD, STATUS_CD)
values
('SHRINE', 'qep', 'DATA_OBFSC', 'A');

insert into PM_USER_PARAMS
(DATATYPE_CD, USER_ID, PARAM_NAME_CD, VALUE, CHANGEBY_CHAR, STATUS_CD)
values
('T', 'qep', 'qep', 'TRUE', 'i2b2', 'A');