HPE NonStop SQL/MX Error – 1177 SELECT cannot be revoked from the executable of a stored routine if the authorization ID has EXECUTE authority.

Data 12 Views 1 Min Read

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

Tags: