More details for creating user

alter session set "_ORACLE_SCRIPT"=true;  
drop user SMARTHCM_ABC cascade;
-- Create the user 
create user SMARTHCM_ABC
  identified by SMARTHCM_ABC
  default tablespace SMARTHCM
  temporary tablespace TEMP
  profile DEFAULT
  password expire;
-- Grant/Revoke role privileges 
grant connect to SMARTHCM_ABC;
grant dba to SMARTHCM_ABC;
grant dba to SMARTHCM_ABC;
grant resource to SMARTHCM_ABC;
-- Grant/Revoke system privileges 
grant create any directory to SMARTHCM_ABC;
grant create any job to SMARTHCM_ABC;
grant create materialized view to SMARTHCM_ABC;
grant create synonym to SMARTHCM_ABC;
grant create table to SMARTHCM_ABC;
grant create view to SMARTHCM_ABC;
grant debug connect session to SMARTHCM_ABC;
grant unlimited tablespace to SMARTHCM_ABC;
grant unlimited tablespace to SMARTHCM_ABC;