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
