Create a User

connect system/system

CREATE USER user3          -- define user name
IDENTIFIED BY pass3        -- assign password
DEFAULT TABLESPACE users   -- assign tablespace for their work (select tablespace_name from dba_data_files;)
TEMPORARY TABLESPACE temp  -- assign temp space for 'order bys'
QUOTA 0 ON SYSTEM          -- allow no usage of this area
QUOTA UNLIMITED ON users   -- allow as much as they need here
PROFILE clerk              -- attach a profile
ACCOUNT LOCK
;

CREATE USER user3
IDENTIFIED BY pass3
TEMPORARY TABLESPACE temp
QUOTA 0 ON SYSTEM
QUOTA UNLIMITED ON users
PROFILE clerk
ACCOUNT LOCK
;