Create Schema

SQL> create tablespace GGODS datafile 'GGODS.dat' size 100M autoextend on;
Tablespace created.
SQL> create user ggods identified by ggods  default tablespace GGODS;
User created.
SQL> grant connect to ggods;
Grant succeeded.
SQL> grant resource to ggods;
Grant succeeded.
SQL> conn ggods/ggods
Connected.

CREATE SCHEMA AUTHORIZATION oe
   CREATE TABLE new_product 
      (color VARCHAR2(10)  PRIMARY KEY, quantity NUMBER) 
   CREATE VIEW new_product_view 
      AS SELECT color, quantity FROM new_product WHERE color = 'RED' 
   GRANT select ON new_product_view TO hr;