HPE NonStop SQL/MX Error – 1012 No privileges were granted. You lack grant option on the specified privileges.

In this blog post, let’s learn about the error message “1012 No privileges were granted. You lack grant option on the specified privileges.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

1012 No privileges were granted. You lack grant option on the specified privileges.

Reason for the Error

You attempted to grant privileges for which you do not have grant options.

Solution

You must have grant options for privileges to grant them