create-schema-lol.sql

-- 1. Create 'schema' ;)

create tablespace test_user_ts
datafile 'test_user_tabspace.dat'
size 10M reuse
autoextend on next 500K;

create temporary tablespace test_user_ts_tmp
tempfile 'test_user.tabspace_temp.dat'
size 10M reuse
autoextend on next 500K;

create user test_user
identified by test_password
default tablespace test_user_ts
temporary tablespace test_user_ts_tmp;

grant create session to test_user;

grant all privileges to test_user;

-- 2. Connect to db as test_user

-- 3. Clean up

drop user test_user cascade;

drop tablespace test_user_ts_tmp;

drop tablespace test_user_ts;