In this blog post, let’s learn about the error message “1036 Only super ID can execute DROP SQL.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1036 Only super ID can execute DROP SQL.
Reason for the Error
An attempt was made to drop SQL by a user who is not the super ID.
Solution
The super ID must issue the DROP SCHEMA statement