Issue in Analytic privilege

[Former Member]

Hi,

I have created an analytic privilege (AN_PRIV1) for a calculation view(CV1) which is calling another attribute view(AT1)

and granted the privilege to user USER1.

I am facing "SAP DBTech JDBC: [258]: insufficient privilege: search table error:  [2950] user is not authorized" error if I use AT1 view in CV1.

The same calculation view is working if I use table instead of attribute view.

Analytic privilege type : I tried this scenario in both classical and SQL analytic privileges.

Access granted to the user:

1. select and execute accesses for schemas _SYS_BIC and _SYS_BI

2. repo.read access to "Root Package"

3. execute access to Repository_rest.

4. AN_PRIV1 analytic privilege  which is created my me.

Can anyone tell me why the above scenario is not working.

Thanks and Regards,

Ranjith.

[varma_narayana · Accepted solution]

Hi Ranjith,

In the attribute view properties (Semantics node --> View properties), have you set the "Apply Privileges" to BLANK? In that case it should not give you this authorization error.

If you have set the "Apply Privileges" to either SQL or Classic, then you have to include this Attribute view also in your analytic privilege definition along with the calculation view.

Hope that helps in resolving your issue.

regards,

Varma

[former_member183326]

Please see: