source: heron_load/create_datamart_schema.sql

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

Merge with demo_concepts_3800

File size: 999 bytes
Line 
1/** create_datamart_schema.sql -- create oracle user for i2b2 datamart
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 * cribbed from create_db_user task in i2b2-backend-deploy
8 *
9 * cf "2 b. Create user accounts in Oracle "
10 * in i2b2 Data Installation Guide Release 1.4
11 *
12 * Note the use of sqlplus variable syntax: &&xyz
13 * and whenever sqlerror continue/exit.
14 * see db_util.run_script() for details.
15 */
16
17whenever sqlerror continue;
18drop user &&name cascade;
19whenever sqlerror exit;
20
21CREATE USER &&name IDENTIFIED BY &&passwd DEFAULT TABLESPACE &&tspace;
22GRANT RESOURCE TO &&name;
23GRANT CREATE TYPE TO &&name;
24GRANT CREATE ROLE TO &&name;
25GRANT CREATE TABLE TO &&name;
26GRANT CREATE VIEW TO &&name;
27GRANT CREATE PROCEDURE TO &&name;
28GRANT CREATE SEQUENCE TO &&name;
29GRANT CREATE TRIGGER TO &&name;
30-- GRANT UNLIMITED TABLESPACE to REDCAPMETADATA&&pid; needed?
Note: See TracBrowser for help on using the repository browser.