cancel
Showing results for 
Search instead for 
Did you mean: 

SAP Hana database roles table

3,123

Dear Experts,

Please advise if there is any view/table in SAP hana database to find out relation between roles.

Similar to Composite and simple role concept, we have role and part of role concept in Hana. i would like to know which role is part of which role and which roles gives access to which roles

Accepted Solutions (1)

Accepted Solutions (1)

dvankempen
Product and Topic Expert
Product and Topic Expert

Hi Vamsi,

The ROLES system view contains that information and GRANTED_ROLES and EFFECTIVE_ROLES provide information on who got what.

For some more background information, see

Answers (0)