Create the user
create user HR
identified by ""
default tablespace USERS
temporary tablespace TEMP
profile DEFAULT
password expire
quota unlimited on users;
-- Grant/Revoke object privileges
grant execute on DBMS_STATS to HR;
-- Grant/Revoke role privileges
grant connect to HR;
grant resource to HR;
-- Grant/Revoke system privileges
grant alter session to HR;
grant create database link to HR;
grant create sequence to HR;
grant create session to HR;
grant create synonym to HR;
grant create view to HR;
grant unlimited tablespace to HR;