cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Saritha_K
Contributor
0 Kudos

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
0 Kudos

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

Answers (1)

Answers (1)

gowrisankar_m2
Employee
Employee
0 Kudos

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