Previous Topic: -312 - NO SQLDA FOR EXECUTE OF A STATEMENT WITH PARAMETER MARKERSNext Topic: -314 - EXTERNALLY SECURED PLANS REQUIRE AUTHID.PLAN-NAME < 26 BYTES

SQL Codes › SQL Return Codes -1 through -999 › -313 - NO SUCH PRIVILEGE IS grantable or revokable ON object_name

-313 - NO SUCH PRIVILEGE IS grantable or revokable ON object_name

Explanation

The GRANT or REVOKE statement contains a privilege that is not allowed with the specified object_name (plan, table, view)

The SQLSTATE that equates to this SQL return code is 42S07.

User Response

Modify the GRANT or REVOKE by changing the privilege or object type.