In sufficient privilege calling procedure in calc view

[former_member224444]

Hi All,

I have created a stored procedure which uses select query on analytical view.  But when i call that procedure inside calculation view, it says in sufficient privilege even after executing GRANT SELECT ON <SCHEMA NAME> TO "_SYS_REPO" WITH GRANT OPTION. Please help on this.

Thanks,

Rithika

[former_member183326]

Try looking here, troubleshoot by using the authorization trace:

[former_member224444]

Hi Mike,

I am using HANA cloud system. When i execute the command to set trace am getting change not allowed error:

"Could not execute 'alter system alter configuration ('indexserver.ini','SYSTEM') SET ('trace','authorization')='info' ...' in 58 ms 872 µs .

SAP DBTech JDBC: [2]: general error: change not allowed for tenant database "

Thanks,

Rithika

[former_member183326]

From the error it seems you are running this on the tenant and not the system db. I am not too familiar with the trial instances. Is this a MDC system?

[former_member224444]

Yes this is MDC system. I am calling procedure which in turn uses select query on analytical view, but i have already used grant select on the base table used in data foundation of analytical view, but still i am getting this error.

Thanks,

Rithika

[former_member183326]

ok, try running the SQL on the SYSTEM DB, reproduce the issue, then turn the trace off.

Upload the new indexserver trace file then here/