Skip to main content
Updates the specified SCHEMA.

​
ALTER SCHEMA OWNER TO

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

​
Syntax

ALTER SCHEMA <schema> OWNER TO <user>

​
Parameters

ParameterDescription
<schema>Name of the schema to change the owner of.
<user>The new owner of the schema. Can be either a user name or a role name.