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

PlatformPadawan
Tera Contributor

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

PlatformPadawan_0-1741011478777.png

 

 

7 REPLIES 7

Hi @PlatformPadawan 

Technically, a user can see a table if they have the required role. So, you first need to find out which role you're looking for. Then, go to the role, and you can see the modules as a related list that will tell you which modules a user with that role can access.

Ankur Bawiskar
Tera Patron

@PlatformPadawan 

I don't think it's a valid business requirement.

Database views can be exposed as reports on dashboards but what value it adds?

If my response helped please mark it correct and close the thread so that it benefits future readers.

AndersBGS
Tera Patron

Hi @PlatformPadawan ,

 

First of all, as @Dr Atul - LNG have mentioned, you need to investigate with roles does provide access to these tables? Secondly, when you have this figured out, you can just look in the sys_user_has_role list.