Skip to Content

Authorization issue calling procedure created by other user

Hi Experts,

When I call a procedure created by another user "AVISEK", I get below error.

SAP DBTech JDBC: [430]: invalidated procedure: PROC_LOAD_HIST_TABLE

The Procedure was created by "AVISEK" with the SQL Security of 'Invoker'

and it performs insert/delete on table "HIST_TABLE".

When I Compare Object Priviledge of mine with "AVISEK", I found that same object priviledge on the schema has been granted to both of us (through a common Role).

(Image attached).

Please note:

When I create a procedure with exactly same script as the above procedure and call the procedure, I am able to execute it successfully.

Regards,

Krishnendu.

Capture.JPG (20.1 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Oct 31, 2014 at 03:11 AM

    Hi There,

    Just recreate your procedure. It should work fine.

    Regards,

    Krishna Tangudu

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 30, 2014 at 05:21 PM

    Hi Krishnendu,

    What release of HANA are you running? I'm assuming this is hdbprocedure and not deprecated procedure. Just wondering about that and if the schema is being saved in AVISEK's personal schema or elsewhere. Ie; You both have access to the schema that is being written to but where is the procedure stored. The first line of the procedure;

    PROCEDURE "SCHEMA_NAME"."YOUR_PROCEDURE"

    What is SCHEMA_NAME?

    -Patrick

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.