SAP Hana database roles table

[former_member409309]

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

[dvankempen]

You asked a question. Don't forget to mark the answer that helped you most as correct. Thanks!

For the readers, before you leave, don't forget to up/down vote the answers. You can vote on the question too. Thanks.

[dvankempen · Accepted solution]

Hi Vamsi,

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

• ROLES System View, SAP HANA SQL Reference Guide for SAP HANA Platform

For some more background information, see

• Recommendations for Database Users, Roles, and Privileges, SAP HANA Security Checklists and Recommendations
  
• Database Roles, Security Guide - explains about predefined catalog roles, the difference between runtime and design-time roles, HDI
• Setting Up Roles and Privileges, Developer Guide