Date: Thu, 28 Mar 2024 17:06:50 -0400 (EDT) Message-ID: <1301202279.808.1711660010685@prodopencatalystconfluence.catalyst> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_807_56837396.1711660010682" ------=_Part_807_56837396.1711660010682 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
If the setting for the Data Steward topic creation is set to 'Pe= nding' within shrine.conf, this means that any query topics that are create= d 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 ha= s the ability to approve or reject them. If a topic is approved, then the t= opic will appear in the SHRINE webclient when the user who requested it sig= ns 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 i2b2p= m database and add a special parameter ('DataSteward') to an existing user.=
For example, this code fragment creates a new user called 'shr= ine_steward' and gives it Data Steward privileges. For existing users,= you will just need the last insert statement to add parameters to that use= r.
insert into PM_US= ER_DATA (user_id, full_name, password, status_cd) values ('shrine_steward', 'SHRINE Data Steward User', '5f4dcc3b5aa765d61d8327deb88= 2cf99', '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');