Changing ownership of a schema

Prerequisites
To change ownership of a schema, log in as the Security Administrator or the SUPER.SUPER user if the Security Administrator group is empty.

Procedure

  1. Log on to the NonStop SQL/MX Database Manager.
  2. In the navigation tree, select Database > My Systems > Catalog.
  3. Right-click on a schema and select Change Ownership > Give Schema.
  4. Select the user name in the Set Owner To drop-down menu.
  5. Optional. Select 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.