In this blog post, let’s learn about the error message “1177 SELECT cannot be revoked from the executable of a stored routine if the authorization ID has EXECUTE authority.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1177 SELECT cannot be revoked from the executable of a stored routine if the authorization ID has EXECUTE authority.
Reason for the Error
You attempted to REVOKE SELECT privilege on the EXECUTABLE from a user who has EXECUTE privilege for the target function. If a user has EXECUTE privilege on a function, the user must also have SELECT on the EXECUTABLE.
Solution
Remove SELECT privilege from the EXECUTABLE using REVOKE EXECUTE on the function from the user
