Hitachi

Hitachi Advanced Database Messages


KFAA30607-E

Definition SQL statements cannot be used on another user's aa....aa. (M+J+O)

Schema belonging to other HADB users cannot be changed. <SQLSTATE:42K14>

This message is output in the following cases:

  • If a schema name that does not belong to the executing HADB user was specified when a base table, viewed table, or index is defined.

  • If a schema name that does not belong to the executing HADB user was specified when a base table, viewed table, or index is deleted.

  • If a schema name that does not belong to the executing HADB user was specified when a viewed table is re-created.

  • If an attempt was made to define an index in a base table that specifies a schema name that does not belong to the executing HADB user when an index is defined.

This message is also output if the schema name specified in a definition SQL statement is different from the authorization identifier that was in use when an HADB server was connected.

aa....aa:
  • schema: Schema

S:

Ignores this SQL statement. Alternatively, the system invalidates this transaction.

Action:

If the specified schema name contains errors, correct the errors. Alternatively, check whether the authorization identifier in use when the HADB server was connected is incorrect.