Recovering change ownership of a schema Procedure Log on to the NonStop SQL/MX Database Manager. In the navigation tree, select Database > My Systems > Catalog. Right-click on a schema and select Change Ownership > Give Schema. Click Recover.