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;