Hitachi

Hitachi Advanced Database Messages


KFAA30548-E

The user does not have permission to access the specified schema or schema object. (schema name = "aa....aa", schema object name = "bb....bb") (M+J+O)

You do not have the privileges to access the schema or schema object that was specified. <SQLSTATE: 42820>

The possible causes are as follows:

  • The specified schema does not exist.

  • The specified schema object does not exist.

  • You do not have access privileges to the specified schema object.

aa....aa:

Schema name

bb....bb:

Schema object name

S:

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

Action:

Check the following:

  • Are the correct names specified for the schema, table, and index?

  • Ask the HADB user who has the grant option of access privileges for the target schema object to grant you access privileges for the schema object.

  • If the specified schema object is a viewed table that you own, make sure that the viewed table has not been invalidated. Then, ask the HADB user who has the grant option of access privileges for the underlying table to grant you access privileges for the underlying table of the viewed table.