CODE EXAMPLE FOR SQL

oracle allow space to user

-- To change allowed space to a schema's USERS tablespace
ALTER USER MY_SCHEMA QUOTA 5G ON users;