If the setting for the Data Steward topic creation is set to 'Pending' within shrine.conf, this means that any query topics that are created have to be approved by a designated person 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.

For example, 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');
  • No labels