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;