4004,Unknown table name - simple question

[Former Member]

I am an Oracle person - so this is probably a super simple question.

I am new to MaxDB, and I can not get this very simple query to work - I am logged in as SUPERDBA:

dbmcli on GRD>sql_execute select count(*) from SAPGRD.AGR_TIME

ERR

-24988,ERR_SQL: SQL error

-4004,Unknown table name:AGR_TIME

Can someone point me in the right direction? That would be great.

Thanks,

Sean

[Melanie]

In addition to Elke's answer:

another option would be to logon as SAPGRD user...

Regards,

Melanie

[Former Member]

Hi,

you are connect as user SUPERDBA.

The schema-name of the name you want to select is SAPGRD, meaning: it had been created by a different user.

User A is not allowed to see tables of user B unless he got the privilege to see it. Therefore he will receive error -4004, no matter if user A is a normal user, a DBA or is the systemdba.

Therefore user B ( SAPGRD ) has to GRANT (see reference manual) the select-privilege on this table to all users or to one/some specific user(s) ( SUPERDBA in your example ).

Elke