Previous Topic: -247 - accessor-id HAS NO CREATE SCHEMA AUTHORITYNext Topic: -249 - REFERENCED TABLE aaa.ttt PLUS n OTHERS IN CHECK STATUS


-248 - accessor-id HAS NO AUTHORITY TO USE "GRANTED BY" FORM OF REVOKE

Explanation

The accessor ID provided in the message text does not have the authority required to execute the SQL statement.

The SQLSTATE that equates to this SQL return code is 42502.

User Response

None. Only users designated as Global Owners in the Security Facility may execute the GRANTED BY form of the REVOKE statement.