Page History

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 your own password's MD5 hash provided by the python script.

insert into PM_PROJECT_USER_ROLES (PROJECT_ID, USER_ID, USER_ROLE_CD, STATUS_CD) values ('ACTSHRINE', 'shrine', 'USER', 'A');

insert into PM_PROJECT_USER_ROLES (PROJECT_ID, USER_ID, USER_ROLE_CD, STATUS_CD) values ('ACTSHRINE', 'shrine', 'DATA_AGG', 'A');

insert into PM_USER_DATA (user_id, full_name, password, status_cd) values ('researcherUserName', 'Researcher Full Name', 'hashForResearcherPassword', 'A');
 
insert into PM_PROJECT_USER_ROLES (PROJECT_ID, USER_ID, USER_ROLE_CD, STATUS_CD) values ('ACTSHRINE', 'researcherUserName', 'USER', 'A');

insert into PM_PROJECT_USER_ROLES (PROJECT_ID, USER_ID, USER_ROLE_CD, STATUS_CD) values ('ACTSHRINE', 'researcherUserName', 'DATA_OBFSC', 'A');