Change Owner

From DBArtisan
Jump to: navigation, search

Go Up to Available object actions by DBMS

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

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