insufficient privilege while accessing schema in AMDP

[Former Member]

Hi,

I have this small AMDP which is accessing tables from HDB schema.

could anybody please let me know what authorization / privilege setting i need to make to fix this. i created this schema under user 'SYSTEM'.

Thank you

[Former Member]

img01.jpg

not sure why image was so blur so attaching here as well.

[pfefferf · Accepted solution]

You have to assign SELECT privileges for the schema to the user which is used for the DB connection.

Regards,
Florian

[Former Member · Accepted solution]

Thanks Florian. how would i know which user is being used for DB connection in my system. could you please tell.

Rgds

[Former Member · Accepted solution]

is this the one mention in DBACOCKPIT t code?

[pfefferf · Accepted solution]

For instance you can get it from table DBCON for your connection.

[Former Member · Accepted solution]

This seems worked. Thank you!

now there is no error but when im debugging it further it seems it is not finding tables in default schema so not giving desire result. My Db user is SAPABAP1 so does it mean that i must save all my tables into schema SAPABAP1?

may be i need to open another thread for this.

Rgds