$ 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