Skip to Content
author's profile photo
Former Member

SAP DBTech JDBC: [258]: insufficient privilege: Not authorized

Hi

I have privileges in SAPABAP1 schema with all GRANTABLE Options.

However , When try to view tables into this schema, the system send this msg.

I'm using SYSTEM user. I'm try with

GRANT SELECT ON SCHEMA SAPABAP1 TO _SYS_REPO WITH GRANT OPTION;

But HANA sen this Message

Please your Help

Grant Option.jpg (111.5 kB)
Grant Option1.jpg (183.8 kB)
Grant Option2.jpg (82.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    Posted on Jul 23, 2015 at 06:20 AM

    Hi,

    The third error message that you got is correct. Only schema user SAPABAP1 can grant rights to SYSTEM in your case.

    Since you are facing issues while accessing the table through SYSTEM user, you have two options to resolve it-

    option 1 login with SAPABAP1 user and grant rights to SYSTEM.

    option 2 You can login using SAPABAP1 and try accessing that table.


    Please try this and let us know.

    Regards,

    Saritha K

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 23, 2015 at 06:17 AM

    you are trying with below wrong command in the screenshot i can see,

    GRANT SELECT ON SCHEMA SAPABAP1 TO SYSTEM WITH GRANT OPTION;


    Please try with


    GRANT SELECT ON SCHEMA SAPABAP1 TO _SYS_REPO WITH GRANT OPTION;


    BR,Gowrisankar

    Add comment
    10|10000 characters needed characters exceeded