summaryrefslogtreecommitdiff
path: root/db/oracle/setup
blob: 87964bda6b406b89bd2a422c5c5ccb0215d10718 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
$ 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;

=======

If running an OCI-based client under valgrind you get "ORA-12546: TNS:
permission denied", then you need to set the TWO_TASK environment
variable:

export TWO_TASK=<service name>

For example:

export TWO_TASK=xe