Change Owner

Go Up to [[Available object actions by DBMS{{#if:||{{{2}}}}}]]

This action lets you generate and submit an ALTER objecttype objectname OWNER TO newobjectname statement, for one or more selected objects of the following types:

Domains	Functions	Schema	Tables
Tablespaces	Types	Views

This lets you specify a new owner for the object.

Platform Availability

• PSTGRS *

To change the owner of an object

1. Initiate a Change Owner action against one or more objects of an object type shown in the table above. For more information see Initiating an object operation.
2. Use the following table as a guide to understanding and modifying settings in the Change Category wizard:

Step	Settings and tasks
Action options	From the New Owner dropdown, choose a new owner for the object.
Preview	Displays the DDL that will execute the object action. For details, see Preview.

3. Click Execute. For information on the scheduling option, see Scheduling.

Topics

• Change Schema