Skip to Content
0
5 days ago

HANA - SQL to CREATE STRUCTURED PRIVILEGE

76 Views Last edit 5 days ago 2 rev

Hello,

just wanted to create a simple analytical privilege based on a graphical calculation view without any filter. To do so I was following the documentation here:

CREATE STRUCTURED PRIVILEGE Statement (Access Control)

CREATE STRUCTURED PRIVILEGE <privilege_name> FOR <action>

ON <view_name> <filter_condition>;

and failed.

Current situation:

  • System: HANA 2.00.061.00, xs classic in use.
  • Calculation view "TEST" has been created in package "TRAINING" in Eclipse. "SQL Analytic Privilege" has been applied for this CV.

When trying to create an analytical privilege in SQL by running the statement:

CREATE STRUCTURED PRIVILEGE "TRAINING/AP_TEST1" FOR SELECT

ON "_SYS_BIC"."TRAINING/TEST"

I got this response:

Could not execute 'CREATE STRUCTURED PRIVILEGE "TRAINING/AP_TEST1" FOR SELECT ON "_SYS_BIC"."TRAINING/TEST"'

SAP DBTech JDBC: [257]: sql syntax error: line 2 col 18 (at pos 77)

2 Questions:

1. Where to find the executed statement, which was processed while activation of the AP created in Eclispe?

2. How to change my sql statement that it is working on HANA XS?

Many many thanks for taking time to provide a useful hint.

Br.

Telli