-- login as dba
-- create user , assign tablespaces
mag@mutation_mutation > create user test 
  2  identified by test
  3  default tablespace users
  4  temporary tablespace temp;

User created.
-- grant roles, privs
mag@mutation_mutation > grant resource,connect to test;

Grant succeeded.
mag@mutation_mutation > connect test/test
Connected.
mag@mutation_mutation >