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.