create user bomuser identified by bomuser;
grant CREATE PUBLIC SYNONYM to bomuser;
grant CREATE SEQUENCE to bomuser;
grant CREATE SESSION to bomuser;
grant CREATE SYNONYM to bomuser;
grant CREATE TABLE to bomuser;
grant DROP PUBLIC SYNONYM to bomuser;
CREATE SMALLFILE TABLESPACE "bomTS" LOGGING DATAFILE '/home/data/oracle/oradata/DBNAME/passdb.dbf' SIZE 10M AUTOEXTEND
ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
ALTER USER bomuser tablespace "bomTS";
ALTER USER bomuser UNLIMITED ON "bomTS";
GRANT UNLIMITED TABLESPACE TO bomuser;