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
-
Log on to the NonStop SQL/MX Database Manager.
-
In the navigation tree, select
.
-
Right-click on a schema and select
.
-
Select the user name in the
Set Owner To drop-down menu.
-
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.