Hi Team,
Could you please provide the list of HANA tables that store Users, Roles & privileges.
Thanks for your help in advance!
Regards,
Krishna
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
Thanks venkat and all for your valuable inputs.
Regards,
Krishna
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.
Maybe you can search the corresponding tables in https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.01/en-US -> System Views Reference.