Skip to Content

insufficient privilege while accessing schema in AMDP

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Mar 07, 2017 at 02:53 PM

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

    Regards,
    Florian

    Add comment
    10|10000 characters needed characters exceeded

    • 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