Authorization issue calling procedure created by other user

[former_member185403]

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.

[former_member182302 · Accepted solution]

Hi There,

Just recreate your procedure. It should work fine.

Regards,

Krishna Tangudu

[former_member185403 · Accepted solution]

Hi Krishna,

I shall ask the user "AVISEK" to recreate the Procedure, but I want to mention that the user "AVISEK" is able to run the existing procedure successfully that he created in 'SAPERP' schema.

Regards,

Krishnendu.

[former_member182302 · Accepted solution]

This message

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

Is not an authorization issue message. It normally comes when you have changed any of the objects you were using in the procedure .

So do check once after recreation

Regards,

Krishna Tangudu

[former_member185403 · Accepted solution]

Thanks Krishna.

I am going to ask the user "AVISEK" to call the Procedure once again..

Also I shall ask to re-create the procedure.

I shall come back with the result soon.

[former_member185403 · Accepted solution]

Thanks Krishna,

The error message has been resolved by Re-creating the Procedure.

Now we faced another error while calling the Procedure using hdbsql.

We are investigating with the BASIS team on the same.

Regards,

Krishnendu Roy.

[former_member182302 · Accepted solution]

Welcome Krishnendu.

Regards,

Krishna Tangudu

[Former Member · Accepted solution]

This message was moderated.

[patrickbachmann]

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

[former_member185403]

Hi Patrick,

The Procedure is stored in common SAPERP schema where developers have common access (through a role).

Also none of the Developers are the owner of the schema.

Only the Procedure is created by user "AVISEK"

Thanks and Regards,

Krishnendu.