In this blog post, let’s learn about the error message “1750 WITH GRANT OPTION not allowed for security administrators.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1750 WITH GRANT OPTION not allowed for security administrators.
Reason for the Error
A security administrator attempted to execute a GRANT statement for a privilege using WITH GRANT OPTION for which that security administrator had not explicitly been granted the privilege WITH GRANT OPTION.
Solution
Resubmit the command without the WITH GRANT OPTION