summaryrefslogtreecommitdiff
path: root/db/oracle/setup
diff options
context:
space:
mode:
Diffstat (limited to 'db/oracle/setup')
-rw-r--r--db/oracle/setup14
1 files changed, 14 insertions, 0 deletions
diff --git a/db/oracle/setup b/db/oracle/setup
new file mode 100644
index 0000000..2b96a74
--- /dev/null
+++ b/db/oracle/setup
@@ -0,0 +1,14 @@
+$ su oracle
+$ sqlplus / as sysdba
+
+CREATE USER odb_test
+IDENTIFIED BY odb_test
+DEFAULT TABLESPACE users
+TEMPORARY TABLESPACE temp;
+
+GRANT
+CREATE TABLE,
+CREATE SEQUENCE,
+CREATE TRIGGER,
+CREATE SESSION,
+UNLIMITED TABLESPACE TO odb_test;