In this blog post, let’s learn about the error message “1225 Mixing priv-type privilege with other privileges is not allowed.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1225 Mixing priv-type privilege with other privileges is not allowed.
Reason for the Error
A privilege other than EXECUTE/USAGE is specified in the same GRANT or REVOKE statement, which is not allowed.
Solution
Use separate GRANT or REVOKE statements for EXECUTE/USAGE and other privileges