Skip to Content
avatar image
Former Member

SAP HANA User and role related tables

May 10, 2017 at 11:23 AM | 3.2k Views

Hi Team,

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

Thanks for your help in advance!

Regards,

Krishna

SAP HANA
Security
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Venkateswarlu Nandimandalam
    May 15, 2017 at 04:31 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    RAJ KUMAR S
    May 14, 2017 at 06:54 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Tong Ning
    May 15, 2017 at 02:23 AM

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

    Add comment
    10|10000 characters needed characters exceeded