Skip to Content
0

Values in Analytical Privileges in SAP Hana

Dec 20, 2016 at 01:10 PM

86

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Raj K
Dec 20, 2016 at 01:47 PM
0

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


ap.jpg (117.0 kB)
Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Raj,

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

Thanks,

Arjun

0