HPE NonStop SQL/MX Error – 1267 EXECUTE privilege is incompatible with this object type.

In this blog post, let’s learn about the error message “1267 EXECUTE privilege is incompatible with this object type.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

1267 EXECUTE privilege is incompatible with this object type.

Reason for the Error

You specified a privilege that is not supported for the object type in a GRANT statement.

Solution

Reissue the GRANT statement specifying the valid privilege for the object type