Database view to show tables and users who have access to them
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-03-2025 06:18 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-03-2025 06:40 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-03-2025 06:43 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-03-2025 07:00 AM
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.