SAP HANA User and role related tables

[Former Member]

Hi Team,

Could you please provide the list of HANA tables that store Users, Roles & privileges.

Thanks for your help in advance!

Regards,

Krishna

[former_member437692 · Accepted solution]

Hi Krishna,

Most of the system related information is available under SYS schema as views. For users & roles related stuff, look for following views under SYS schema.

GRANTED_ROLES

GRANTED_PRIVILEGES

ROLES

STRUCTURED_PRIVILEGES

USERS

USER_PARAMETERS

Regards,

Venkat

[Former Member · Accepted solution]

Thanks venkat and all for your valuable inputs.

Regards,

Krishna

[former_member182967]

Maybe you can search the corresponding tables in https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.01/en-US -> System Views Reference.

[former_member417085]

Hi Krishna,

Please refer to below link which gives information regarding the users, role and its assignments.

https://blogs.sap.com/2012/08/31/sap-hana-how-to-analyze-who-has-access-to-particular-object/

Regards

Raj Kumar S.