cancel
Showing results for 
Search instead for 
Did you mean: 

Select Statement

Former Member
0 Kudos
61

Hello there,

i am new in MAX DB and want to make a easy select Statement.

I think this is right?

SELECT * FROM USR02 WHERE BNAME='zztest'

But i become an error:

Error Executing 'SELECT * FROM USR02 WHERE BNAME='zztest'' [-4004] (at 15): Unknown table name:USR02.

So can you tell me whta wrong with this statement?

Thanks

Bjoern

Accepted Solutions (1)

Accepted Solutions (1)

Melanie
Advisor
Advisor
0 Kudos

Hello Björn,

probably you are not logged on as the owner of that table.

Best regards,

Melanie

Former Member
0 Kudos

I logged on as superdba. I thought that is the right user? Is it not?

Former Member
0 Kudos

no you should login as schema user or give <schema user>.<tablename> under superdba

cheers,

-Sunil

Melanie
Advisor
Advisor
0 Kudos

No, it is not. Check out

https://wiki.sdn.sap.com/wiki/x/UC8.

You need to logon as the owner of the aaplication data.

Regards, Melanie

Answers (1)

Answers (1)

Former Member
0 Kudos

Thanks,

i found now a other Thread too