diff options
-rw-r--r-- | db/oracle/setup | 14 |
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; |