on 2020 Apr 17 6:29 AM
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
Request clarification before answering.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
78 | |
12 | |
9 | |
8 | |
7 | |
5 | |
4 | |
4 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.