In this blog post, let’s learn about the error message “1013 Not all privileges were granted. You lack grant option on some of 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
1013 Not all privileges were granted. You lack grant option on some of the specified privileges.
Reason for the Error
You attempted to grant privileges, but you do not have grant options for at least one of them.
Solution
You must have grant options for privileges to grant them