Database view to show tables and users who have access to them

[PlatformPadawan]

Hi all, 

I'm attempting to create a database view to only show certain tables and users who have access to them. I'm currently not able to bring back any data from the tables in my database view. Any help or direction would be appreciated

[Dr Atul G- LNG]

Hi @PlatformPadawan 

The reason is that you need to add the "where" clause for the other tables as well.

[PlatformPadawan]

Not familiar with queries too much, which is why I left some of them blank. What would you suggest I put for the where clauses for the other tables? 

[Dr Atul G- LNG]

Hi @PlatformPadawan 

So, you want to see how many users have a specific role? If yes, then there's no need to create a DB view. You can simply create a report on the Role table.

Please share your exact use case, and I'll be happy to assist you further.

[PlatformPadawan]

At minimum, I need a report to show certain tables and users who have access to those tables