db/oracle/setup


1
2
3
4
5
6
7
8
9
10
11
12
13
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;