Skip to Content
0

insufficient privilege while accessing schema in AMDP

Mar 07, 2017 at 12:14 PM

55

avatar image

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

img01.jpg (162.9 kB)
10 |10000 characters needed characters left characters exceeded

img01.jpg

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

img01.jpg (162.9 kB)
0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Florian Pfeffer
Mar 07, 2017 at 02:53 PM
1

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

Regards,
Florian

Show 4 Share
10 |10000 characters needed characters left characters exceeded

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

Rgds

0

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

0

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

0

is this the one mention in DBACOCKPIT t code?

0