Chapter 8.2 - Setting up the Data Steward user

If the setting for the Data Steward topic creation is set to 'Pending' or 'Approved' within shrine.conf, this means that any query topics that are created have to be approved by a designated role called the 'Data Steward'. The Data Steward is a special role that can see all pending topics and then 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. In order to assign 'Data Steward' privileges, you will need to connect to the i2b2pm database and add a special parameter ('DataSteward') to an existing user.

The following code fragment creates a new user called 'shrine_steward' and gives it Data Steward privileges. To assign the Data Steward privileges to an existing user, you will simply execute the last insert statement to assign the role 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.