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

[Former Member]

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

[Saritha_K · Accepted solution]

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

[Former Member · Accepted solution]

Hi Saritha K

The option 1 login with SAPABAP1 user and grant rights to SYSTEM, is Working

The option 2 You can login using SAPABAP1 and try accessing that table, is working too

Thanks in advance

[gowrisankar_m2]

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