Create a database view to show Roles granted by Group including all contains roles within

Adheshwar1
Tera Contributor

Hello all,

 

    I am new to Database views and would like to learn how to create database view that shows Groups and roles and contains roles. We want to show Roles provided by group including all Contains roles within. Could you help me in creating one? We want to keep going into contains role until it does not have contain role

5 REPLIES 5

Shivalika
Mega Sage

Hello @Adheshwar1 

 

 

Please confirm if you checked my answer. Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for my efforts and also it can move from unsolved bucket to solved bucket. 

 

Regards, 

Shivalika 

 

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

 

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeE