Create Oracle Tablespace & User / Schema & Grant Permissions

Query.sql

CREATE TABLESPACE TBS_ORA_DOCKER_01 DATAFILE 'TBS_ORA_DOCKER_01.dat' SIZE 50M ONLINE;
CREATE TEMPORARY TABLESPACE TBS_TEMPORARY_ORA_DOCKER_01 TEMPFILE 'TBS_TEMPORARY_ORA_DOCKER_01.dbf' SIZE 10M AUTOEXTEND ON;


CREATE USER ORA_DOCKER
  IDENTIFIED BY ORA_DOCKER
  DEFAULT TABLESPACE TBS_ORA_DOCKER_01
  TEMPORARY TABLESPACE TBS_TEMPORARY_ORA_DOCKER_01
  QUOTA UNLIMITED on TBS_ORA_DOCKER_01;


GRANT create session TO ORA_DOCKER;
GRANT create table TO ORA_DOCKER;
GRANT create view TO ORA_DOCKER;
GRANT create any trigger TO ORA_DOCKER;
GRANT create any procedure TO ORA_DOCKER;
GRANT create sequence TO ORA_DOCKER;
GRANT create synonym TO ORA_DOCKER;