Replace views

The CREATE OR REPLACE VIEW command creates a view, or if a view with the same name exists, it replaces the definition of the existing view while retaining the granted privileges on the view.

To transfer view permissions, enter:

   MYDB.SCHEMA(USER)=> CREATE OR REPLACE VIEW viewname AS SELECT query;