This shows you the differences between two versions of the page.
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 ; |