SUIM for SAP HANA

[Former Member]

Is there a user management query tool in HANA where I can check what roles, schemas, priviliges users are granted ?

[former_member187175 · Accepted solution]

Hi Rahul,

does the EFFECTIVE_PRIVILEGES system view fit your needs? It is documented in the SAP HANA Security guide.

e.g. SELECT * FROM "SYS"."EFFECTIVE_PRIVILEGES" where USER_NAME = 'RAHUL';

[Former Member · Accepted solution]

Thank you. the SQL script works. what is the same for Role name ? I entered ROLE_NAME= xxx and it gave me an incorrect value. also if I need to check who has access to the priviliges what is the script for that ?

[former_member187175 · Accepted solution]

There is EFFECTIVE_ROLES, but I think the where clause always needs username.

[Former Member · Accepted solution]

thank you. your answer helps. if I have a analytic view or a calculation view how do i know who has access to this specific view ? is there a view or a table for this ?

[Former Member]

Hi Rahul,

you can check the info under Security in HANA studio navigator pane.