In this blog post, let’s learn about the error message “1753 You must be a security administrator to perform this operation.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1753 You must be a security administrator to perform this operation.
Reason for the Error
An attempt was made by super.super to grant or revoke privileges while the set of security administrators was not empty, super.super was not designated as a security administrator, and super.super did not explicitly have the privilege to grant or revoke the privileges in question.
Solution
Designate super.super as a security administrator or explicitly grant the necessary privileges to super.super, and run the command again