SHRINE 4.0.0 Chapter 9.1 - Setting Up the Data Steward User

The Data Steward user has a special role that can see all topics and has the ability to approve or reject them. If a topic is approved, then the topic will appear in the SHRINE webclient when the user who requested it signs into the webclient. If the topic is rejected, then it will not.

To assign 'Data Steward' privileges connect to the i2b2pm database and add a parameter - DataSteward - to an existing user.

This code fragment creates a new user called 'shrine_steward' and gives it Data Steward privileges. For existing users, you will just need the last insert statement to add parameters to that user.

insert into PM_USER_DATA (user_id, full_name, password, status_cd) values ('shrine_steward', 'SHRINE Data Steward User', '5f4dcc3b5aa765d61d8327deb882cf99', 'A');
 
-- The password hash you see above is for 'password'

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

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

insert into PM_USER_PARAMS (DATATYPE_CD, USER_ID, PARAM_NAME_CD, VALUE, CHANGEBY_CHAR, STATUS_CD) values ('T', 'shrine_steward', 'DataSteward', 'true', 'i2b2', 'A');

Please refer to Chapter 8.1 on information regarding the generation of the password hash.