Page History
...
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.
| Code Block | ||||
|---|---|---|---|---|
| ||||
insert into PM_USER_DATA
(user_id, full_name, password, status_cd)
values
('shrine_steward', 'SHRINE Data Steward User', 'password', 'A');
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'); |
...
Overview
Content Tools