HPE NonStop SQL/MX Error – 1023 Only super ID can name an authorization ID other than the current user name.

In this blog post, let’s learn about the error message “1023 Only super ID can name an authorization ID other than the current user name.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

1023 Only super ID can name an authorization ID other than the current user name.

Reason for the Error

You attempted to create a schema with the authorization ID of another user. Only the super ID can do this.

Solution

Log on as the super user to create a schema with another owner