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

[Former Member]

I have a user entering SQL script ot build a few procedures that access some calculated views. Most work fine, but one crashes with the error

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

The user can use "Data Preview" in HANA Studio, but the script ot build the procedure gives above error. Is there a flag on the CA View that I need to switch to allow user access? It does not make sense that most Views are ok, but this one gives this error.

Thanks, Ira

[henrique_pinto · Accepted solution]

Make sure he's not trying to create or update or delete (write) data in a ReadOnly proc.

[Former Member · Accepted solution]

Thanks for trying to help, Henrique.

I discovered the issue - which was inside the Proc I was trying to reference a table within my own schema which they did not have security for. It really was not that the CA View was the issue.

Sorry for the post.