How to check which user has the create report permission.
When I check the report_user role, the "Users" tab is blank so I'm assuming no one in the instance can create a report. But upon doing some random checking with few HR agents, there are some who can actually create a report.
So not sure what I'm missing here.
Yes, that's expected if you are not on New York and also if you're experiencing someone with sn_hr_core.basic not being able to create reports. You can find all of the roles that allow the creation of reports by looking at the ACLs for create on sys_report. Below are the defaults you should see.
If you're still looking to identify why some users are able to create reports, look for these roles on the sys_user_has_role table. You should notice the users you tested with will appear with these role filters applied.
When I want to know which users have which roles, I go to the table sys_user_has_role. You can filter, group, and report from there.
