CREATE OR REPLACE VIEW myview (vcol1, vcol2, vcol3) AS

   SELECT tcol1, tcol2, tcol3

   FROM mytable;

Read Only View

CREATE OR REPLACE VIEW myview (vcol1, vcol2, vcol3) AS

   SELECT tcol1, tcol2, tcol3

   FROM mytable

   WITH READ ONLY;

Granting Access

GRANT SELECT on user1.view1 TO user2;

If view1 (owned by user1) references table3 owned by user3 then any grant to user2 will 

TODO

DROP VIEW IF EXISTS myschema.myview CASCADE CONTSRAINTS;

Bibliography