oracle create user

Create oracle scheme and user with useful rights

execute by DBA

create user my_user_name identified by User0paSS12wOrd;

alter user my_user_name
DEFAULT TABLESPACE users
TEMPORARY TABLESPACE temp
QUOTA UNLIMITED ON users
ACCOUNT UNLOCK;

GRANT
create session,
CONNECT,
--RESOURCE,  
--DBA,
CREATE DATABASE LINK,
CREATE MATERIALIZED VIEW,
CREATE PROCEDURE,
CREATE PUBLIC SYNONYM,
--CREATE ROLE,
CREATE SEQUENCE,
CREATE SYNONYM,
CREATE TABLE,  
CREATE TRIGGER,
CREATE TYPE,
CREATE VIEW,
CREATE JOB
to my_user_name;