Previous Topic: -246 - INVALID AREA NAME: aaaaNext Topic: -248 - accessor-id HAS NO AUTHORITY TO USE "GRANTED BY" FORM OF REVOKE


-247 - accessor-id HAS NO CREATE SCHEMA AUTHORITY

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 CREATE SCHEMA statement.