Updates the specified VIEW.

​
ALTER VIEW OWNER TO

Change the owner of a view. The current owner of a view can be viewed in the information_schema.views view on view_owner column. check ownership page for more info.

​
Syntax

ALTER VIEW <view> OWNER TO <user>

​
Parameters

ParameterDescription
<view>Name of the view to change the owner of.
<user>The new owner of the view.