Note: We no longer publish the latest version of our code here. We primarily use a kumc-bmi github organization. The heron ETL repository, in particular, is not public. Peers in the informatics community should see MultiSiteDev for details on requesting access.

source: heron_load/create_project_mgr.sql @ 0:42ad7288920a

heron-michigan tip
Last change on this file since 0:42ad7288920a was 0:42ad7288920a, checked in by Matt Hoag <mhoag@…>, 6 years ago

Merge with demo_concepts_3800

File size: 815 bytes
Line 
1/** create_project_mgr.sql -- create user for managing redcap i2b2 projects
2
3Copyright (c) 2012 University of Kansas Medical Center
4part of the HERON* open source codebase; see NOTICE file for license details.
5* http://informatics.kumc.edu/work/wiki/HERON
6*/
7
8whenever sqlerror continue;
9-- From: db_build/bheronDV_build_scripts/CreateDBUsers.sql
10  DROP USER i2b2rcmgr CASCADE;
11  CREATE USER i2b2rcmgr IDENTIFIED BY &&passwd
12  -- Changed it to USERS after talking to bhamlin
13  DEFAULT TABLESPACE USERS
14  TEMPORARY TABLESPACE "TEMP";
15  GRANT CREATE SESSION TO i2b2rcmgr;
16whenever sqlerror exit;
17
18GRANT SELECT ON BLUEHERONMETADATA.REDCAP_TERMS_ENHANCED to i2b2rcmgr;
19GRANT SELECT, UPDATE ON I2B2PM.PM_PROJECT_DATA to i2b2rcmgr;
20GRANT SELECT, UPDATE ON I2B2PM.PM_PROJECT_USER_ROLES to i2b2rcmgr;
Note: See TracBrowser for help on using the repository browser.