Change view ownership

If you are the owner or have the Alter privilege on views, you can change the owner of a view without changing any of its data. The new owner must be a current user of the system.

To change view ownership, enter:
   MYDB.SCHEMA(USER)=> ALTER VIEW emp OWNER TO john;