Working with change ownership feature

Procedure

Prerequisites
The change ownership feature is available for the following objects :

  • Catalog

  • Schema

  • Table

  • Trigger

  • View

  • Procedure

  • Sequence

  • To change ownership of a catalog, log in as one the following:

    • Catalog owner

    • Security Administrator

    • SUPER.SUPER user if the Security Administrator group is empty

  • To change ownership of a schema, log in as one the following:

    • Owner of the schema

    • Security Administrator

    • SUPER.SUPER user if the Security Administrator group is empty

  • To change ownership of a table, trigger, view, procedure, or sequence, log in as one the following:

    • Security Administrator

    • Owner of the schema that contains the object

    • Object owner

    • SUPER.SUPER user if the Security Administrator group is empty

Procedure

  1. Log on to the NonStop SQL/MX Database Manager.
  2. Navigate to the required database object.

    This option is available only for the following objects: catalogs, schemas, tables, triggers, views, procedures, and sequences.

  3. Right-click on a the required object and select Change Ownership.

    Or, to change ownership of a schema, select Change Ownership > Give Schema.

    The Give <object name> window appears.

    For example, if you are changing ownership of a schema, the Give Schema window appears.

  4. Select the user to whom the ownership is being transferred, in the Set Owner To drop-down menu.
  5. Click Ok.
    NOTE:

    For change ownership of a schema, you can select the Cascade option. If you select Cascade option, the ownership of the selected schema and the objects in the schema owned by the current schema owner are transferred. If you clear Cascade option, only the ownership of the selected schema is transferred.