Values in Analytical Privileges in SAP Hana

[Former Member]

Hi Gurus,

We are in process of making changes to about a 100 analytical Privileges in the HANA Roles. Is their an SQL command or a table where we can see the all the Attribute restrictions that we have maintained in Analytical Privileges?

Having all the information in a single place will make it easier to view the changes rather going to each Privilege and check.

We are on SAP HANA Version 1.00.123.03.

Thanks,

Arjun

[rindia · Accepted solution]

Hi Arjun,

There is a table to view all the restrictions with values.

SELECT STRUCTURED_PRIVILEGE_NAME, RESTRICTION_TYPE, FILTER_TYPE, DIMENSION_ATTRIBUTE, OPERATOR, OPERAND FROM STRUCTURED_PRIVILEGES

WHERE STRUCTURED_PRIVILEGE_NAME LIKE '%give_your_package_name%'

ORDER BY STRUCTURED_PRIVILEGE_ID;

ap.jpg

Filter Type Dynamic means value is passed at run time through procedure.

Regards

Raj

[Former Member · Accepted solution]

Hi Raj,

Thanks for the response. I am indeed able to view the analytical Privilege values

Thanks,

Arjun