HPE NonStop SQL/MX Error – 1662 GRANT OPTION cannot be used in combination with a privilege group.

In this blog post, let’s learn about the error message “1662 GRANT OPTION cannot be used in combination with a privilege group.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

1662 GRANT OPTION cannot be used in combination with a privilege group.

Reason for the Error

You specified the WITH GRANT OPTION clause for a GRANT command, or the GRANT OPTION FOR clause for a REVOKE command, in combination with a privilege group grantee.

Solution

Specify correct clause and retry the command