Create DB user in Oracle

-- Check which tablespace can be used
select usermame, DEFAULT_TABLESPACE, TEMPORARY_TABLESPACE from DBA_USERS;

-- Create user
create user xxxx
identified by yyyyy
default tablespace dddddd
temporary tablespace tttttt;

-- Grant resource to user
grant connect to xxxx;
grant resourc to xxxx;