User Tools

Site Tools


documentation:software:webapi:oracle_db_setup_guide

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
documentation:software:webapi:oracle_db_setup_guide [2016/08/23 20:05]
jhardin created
documentation:software:webapi:oracle_db_setup_guide [2019/04/19 16:21] (current)
anthonysena
Line 1: Line 1:
-==== Oracle Setup Guide ====+===== IMPORTANT NOTE ===== 
 + 
 +All WebAPI documentation has moved to [[https://​github.com/​OHDSI/​WebAPI/​wiki|GitHub]]. Please disregard the content below as it is legacy and kept for posterity. 
 + 
 +==== Oracle Setup Guide (LEGACY) ​====
 ---- ----
 === Database Engine Installation === === Database Engine Installation ===
Line 38: Line 42:
   DEFAULT TABLESPACE "​SYSTEM"​   DEFAULT TABLESPACE "​SYSTEM"​
   TEMPORARY TABLESPACE "​TEMP";​   TEMPORARY TABLESPACE "​TEMP";​
- 
   -- QUOTAS   -- QUOTAS
- 
   -- ROLES   -- ROLES
   GRANT "​CONNECT"​ TO ohdsi ;   GRANT "​CONNECT"​ TO ohdsi ;
   GRANT "​RESOURCE"​ TO ohdsi ;   GRANT "​RESOURCE"​ TO ohdsi ;
   ALTER USER ohdsi DEFAULT ROLE "​CONNECT","​RESOURCE";​   ALTER USER ohdsi DEFAULT ROLE "​CONNECT","​RESOURCE";​
- 
   -- SYSTEM PRIVILEGES   -- SYSTEM PRIVILEGES
   GRANT UNLIMITED TABLESPACE TO ohdsi ;   GRANT UNLIMITED TABLESPACE TO ohdsi ;
documentation/software/webapi/oracle_db_setup_guide.1471982749.txt.gz · Last modified: 2016/08/23 20:05 by jhardin