oracle add user

 create user ztest identified by 123;
GRANT CREATE SESSION TO ztest2; -- so can log in

GRANT CREATE Table, create VIEW, CREATE PROCEDURE, CREATE SEQUENCE, CREATE TRIGGER to ztest2;
ALTER USER ztest2 QUOTA 100M ON DMCS;