Getting the list of database objects for a parent role

I have a parent role that is connected to multiple child roles using the hierarchy. Is there a way to identify the list of database objects that the parent has that includes the access of the database objects that the child roles also have using a single query?

AzharuddinK

posted on 09 Apr 20

Enjoy great content like this and a lot more !

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds




nVector02-May-21

Were you able to find out the answer ? If yes, Could you share the solution for the community